Be Alpha
Saturday, August 17, 2019
Current size of file recovery db_recovery_file_dest_size
SELECT name
,
ceil( space_limit / 1024 / 1024) SIZE_M
,
ceil( space_used / 1024 / 1024) USED_M
,
decode( nvl( space_used, 0),
0, 0
, ceil ( ( space_used / space_limit) * 100) ) PCT_USED
FROM v$recovery_file_dest
ORDER BY name
/
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment