News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Monitor the Flashback area space usage

  • Posted by Gavin Soorma
  • On June 29, 2009
  • 0 Comments
SELECT * FROM   V$FLASH_RECOVERY_AREA_USAGE;

SELECT * FROM V$RECOVERY_FILE_DEST;


col ROUND(SPACE_LIMIT/1048576) heading "Space Allocated (MB)" format 999999
col round(space_used/1048576) heading "Space Used (MB)" format 99999
col name format a40



select name, round(space_limit/1048576),round(space_used/1048576)
from  v$RECOVERY_FILE_DEST;
 

0 Comments

Leave Reply

Your email address will not be published. Required fields are marked *