Oracle database check db_recovery_file_dest_size usage

db_recovery_file_dest_size usage

The following scripts will check space utilization for db_recovery_file_dest_size:

col name     format a32
col size_mb  format 999,999,999
col used_mb  format 999,999,999
col pct_used format 999

select

   name,

   ceil( space_limit / 1024 / 1024) size_mb,

   ceil( space_used / 1024 / 1024) used_mb,

   decode( nvl( space_used, 0),0, 0,

   ceil ( ( space_used / space_limit) * 100) ) pct_used

from

    v$recovery_file_dest

order by

   name desc;

*********************************

set lines 100

col name format a60

select

   name,

   floor(space_limit / 1024 / 1024) "Size MB",

   ceil(space_used / 1024 / 1024)   "Used MB",

from

   v$recovery_file_dest

order by

   name;