Personal tools
You are here: Home → Oracle → How To's → How To view current available space in the flash recovery area
Navigation
Log in


Forgot your password?
 
Document Actions

How To view current available space in the flash recovery area

To view current available space in the flash recovery area.



You can view the current available space in the flash recovery area using the statement below:


SELECT NAME,TO_CHAR(SPACE_LIMIT, '999,999,999,999') AS SPACE_LIMIT,
TO_CHAR(SPACE_LIMIT - SPACE_USED + SPACE_RECLAIMABLE, '999,999,999,999')
AS SPACE_AVAILABLE,ROUND((SPACE_USED - SPACE_RECLAIMABLE)/SPACE_LIMIT * 100, 1)
AS PERCENT_FULL FROM V$RECOVERY_FILE_DEST;
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls