Available db recovery file dest

From NazimWIKI
Revision as of 23:36, 8 November 2019 by Admin (talk | contribs) (Created page with "A great script picked up somewhere along the way to check the available amount of db_recovery_file_dest space. <blockquote><pre> SELECT name , floor(space_limit/1024/102...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

A great script picked up somewhere along the way to check the available amount of db_recovery_file_dest space.

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;