Query To Check DB_RECOVERY_FILE_DEST_SIZE Utilization in Oracle

Query To Check DB_RECOVERY_FILE_DEST_SIZE Utilization in Oracle

Script:

set linesize 999

SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;

or

col name for a32

col size_m for 999,999,999

col reclaimable_m for 999,999,999

col used_m for 999,999,999

col pct_used for 999

SELECT name

, ceil( space_limit / 1024 / 1024) SIZE_M

, ceil( space_used / 1024 / 1024) USED_M

, ceil( space_reclaimable / 1024 / 1024) RECLAIMABLE_M

, decode( nvl( space_used, 0),

 0, 0

 , ceil ( ( ( space_used - space_reclaimable ) / space_limit) * 100) ) PCT_USED

 FROM v$recovery_file_dest

ORDER BY name

/

Please do like and subscribe to my youtube channel: https://www.youtube.com/@foalabs If you like this post please follow,share and comment