Loading....
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;
Please follow and like us:

Last Update: June 29, 2009  

June 29, 2009 151 Gavin Soorma
Total 0 Votes:
0

Tell us how can we improve this post?

+ = Verify Human or Spambot ?

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?

, , ,

Leave a Comment

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

*
*

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?