Check Space Fast Recovery Area

From NazimWIKI
Revision as of 23:31, 8 November 2019 by Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT name , floor(space_limit/1024/1024) "Size_MB" , ceil(space_used/1024/1024) "Used_MB" , floor(space_limit/1024/1024) - ceil(space_used/1...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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;