Skip navigation

Enhance Oracle EM KM to include Fast (Flash) Recovery Area Monitoring

score 50
You have not voted. Below Review Threshold

I am raising this IDEA on behalf of SVV.

 

They are working on implementing the new Oracle Enterprise KM, however it does not provide OOTB monitoring of the Fast (Flash) Recovery Area.

 

The following custom SQL allows this to be monitored but it would be preferable if it was included in the default KM.

 

SELECT

  ROUND((A.SPACE_LIMIT / 1024 / 1024 / 1024), 2) AS FLASH_IN_GB,

  ROUND((A.SPACE_USED / 1024 / 1024 / 1024), 2) AS FLASH_USED_IN_GB,

  ROUND((A.SPACE_RECLAIMABLE / 1024 / 1024 / 1024), 2) AS FLASH_RECLAIMABLE_GB,

  SUM(B.PERCENT_SPACE_USED)  AS PERCENT_OF_SPACE_USED

FROM

  V$RECOVERY_FILE_DEST A,

  V$FLASH_RECOVERY_AREA_USAGE B

GROUP BY

  SPACE_LIMIT,

  SPACE_USED ,

  SPACE_RECLAIMABLE;

 

 

Kjetil Klevengen Tommy Rognstad Bjorn Heide Adam Kanas Udi Perlstein Rami Hadad Soumya Pati

Comments

Vote history