Flash recovery area

June 19th, 2015

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
/


Comments are closed.