Available db recovery file dest
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;