flashbacklog.sql查看flashback使用情况

flashbacklog.sql查看flashback使用情况

perfychi
2014-09-04 18:02:17
Oracle
原创

select INST_ID,OLDEST_FLASHBACK_TIME,FLASHBACK_SIZE/1024/1024/1024, ESTIMATED_FLASHBACK_SIZE/1024/1024/1024 from GV$FLASHBACK_DATABASE_LOG;
select * from V$FLASH_RECOVERY_AREA_USAGE;