Check Space Fast Recovery Area

From NazimWIKI
Jump to navigation Jump to search
SELECT name
     , floor(space_limit/1024/1024) "Size_MB"
     , ceil(space_used/1024/1024) "Used_MB"
     , floor(space_limit/1024/1024) - ceil(space_used/1024/1024) "Available_MB"
     , round(ceil(space_used/1024/1024) / floor(space_limit/1024/1024) * 100)  || '%' "Percent Used"
  FROM v$recovery_file_dest
ORDER BY name;