Flash recovery area



Flash recovery area free space


set linesize 200
set verify off
set pagesize 9999

COLUMN Name     			FORMAT a24            	  	HEADING 'Name'
COLUMN Space_Limit     		FORMAT 999,999,999,999,999  HEADING 'Space Limit'
COLUMN Space_Used     		FORMAT 999,999,999,999,999  HEADING 'Space Used'
COLUMN Space_Reclaimable    FORMAT 999,999,999,999,999  HEADING 'Space Reclaimable'
COLUMN Space_available  	FORMAT 999,999,999,999,999  HEADING 'Space Available'
COLUMN Percent_full  		FORMAT 999.99    	      	HEADING 'Percent full'

SELECT 
NAME,
SPACE_LIMIT,
SPACE_USED,
SPACE_RECLAIMABLE,
(SPACE_LIMIT - SPACE_USED + SPACE_RECLAIMABLE) AS SPACE_AVAILABLE,
ROUND((SPACE_USED - SPACE_RECLAIMABLE)/SPACE_LIMIT * 100, 1) AS PERCENT_FULL
FROM V$RECOVERY_FILE_DEST
/

<br />
set linesize 200<br />
set verify off<br />
set pagesize 9999</p>
<p>COLUMN Name     			FORMAT a24            	  	HEADING 'Name'<br />
COLUMN Space_Limit     		FORMAT 999,999,999,999,999  HEADING 'Space Limit'<br />
COLUMN Space_Used     		FORMAT 999,999,999,999,999  HEADING 'Space Used'<br />
COLUMN Space_Reclaimable    FORMAT 999,999,999,999,999  HEADING 'Space Reclaimable'<br />
COLUMN Space_available  	FORMAT 999,999,999,999,999  HEADING 'Space Available'<br />
COLUMN Percent_full  		FORMAT 999.99    	      	HEADING 'Percent full'</p>
<p>SELECT<br />
NAME,<br />
SPACE_LIMIT,<br />
SPACE_USED,<br />
SPACE_RECLAIMABLE,<br />
(SPACE_LIMIT - SPACE_USED + SPACE_RECLAIMABLE) AS SPACE_AVAILABLE,<br />
ROUND((SPACE_USED - SPACE_RECLAIMABLE)/SPACE_LIMIT * 100, 1) AS PERCENT_FULL<br />
FROM V$RECOVERY_FILE_DEST<br />
/<br />