rem
rem Name: log_stat.sql
rem
rem FUNCTION: Get current status ofredo logs
rem
rem
column first_change# format 99999999 heading Change#
column group# format 9,999 heading Grp#
column thread# format 999 heading Th#
column sequence# format 999,999 heading Seq#
column members format 999 heading Mem
column archived format a4 heading Arc?
COLUMN first_time HEADING First|Time
break on thread#
set pages 60 lines 78 feedback off
start title80 'Current Redo Log Status'
spool log_stat
select thread#, group#, sequence#,
bytes, members,archived,status,first_change#,first_time
from sys.v_$log
order by thread#, group#;
spool off
pause Press Enter to continue
set pages 22 lines 80 feedback on
clear breaks
clear columns
ttitle off