Note: Technical Talk being moved to:
www.nazimcricket.com/wiki


Monday, 12 December 2011

Available db_recovery_file_dest

A gr8 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;