alter session set nls_date_format='DD-MON-YYYY HH24:MI:ss';
col OLDEST_FLASHBACK_SCN for 999999999999999
col name for a80
set lines 140 pages 3000
select name,SPACE_LIMIT/1024/1024 limit_mb,SPACE_USED/1024/1024 used_mb,round((SPACE_USED/SPACE_LIMIT)*100,2) percent_usage from V$RECOVERY_FILE_DEST;
select * from V$FLASH_RECOVERY_AREA_USAGE;
select estimated_flashback_size,flashback_size,oldest_flashback_scn,oldest_flashback_time from v$flashback_database_log;
SELECT * FROM gv$flashback_database_stat;
set heading off
select '---------------' from dual;
select 'Flashback usage' from dual;
select '---------------' from dual;
set heading on
@/home/casenaem/flash_back_free.sql
set heading off
select '---------------' from dual;
select 'Restore Points' from dual;
select '---------------' from dual;
set heading on
select * from V$RESTORE_POINT;
No comments:
Post a Comment