SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE; SELECT * FROM V$RECOVERY_FILE_DEST; col ROUND(SPACE_LIMIT/1048576) heading "Space Allocated (MB)" format 999999 col round(space_used/1048576) heading "Space Used (MB)" format 99999 col name format a40 select name, round(space_limit/1048576),round(space_used/1048576) from v$RECOVERY_FILE_DEST;
Monitor the Flashback area space usage
最新推荐文章于 2011-05-19 16:44:00 发布