recovery_file_dest full?
Hey, I have this:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
Then I do this:
select
name,
round(space_limit/power(2,30)) as limit_gb,
round(space_used/power(2,30)) as used_gb,
round(space_reclaimable/power(2,30)) as reclaimable_gb,
round((space_used-space_reclaimable) / power(2,30))as real_used,
round((space_used-space_reclaimable) / space_limit * 100) as pct_real_used,
number_of_files
from v$recovery_file_dest;
NAME
------------------------------------------------------------------------------------------------------------------------------------
LIMIT_GB USED_GB RECLAIMABLE_GB REAL_USED PCT_REAL_USED NUMBER_OF_FILES
---------- ---------- -------------- ---------- ------------- ---------------