Difference between revisions of "Available db recovery file dest"
Jump to navigation
Jump to search
(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...") |
(No difference)
|
Latest revision as of 23:36, 8 November 2019
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;
