SQL Script Monitor Redo Logs

Updated : 29-March-2002
Version : 2.0

Description

Simple listing of redo log status and the key system statistics. The key statistics will be since the last instrance startup, so the instance startup time is displayed.

Parameters

None.

SQL Source

set pages 200

spool monredo.lst

col member form a40

select a.group#, bytes, a.status, member
from v$log a, v$logfile b
where a.group#=b.group#
/

select name,value from v$sysstat
where (name like '%redo%'
or name like '%checkpoint%')
and value != 0
/ 


spool off

Return to Index of SQL Scripts

Home | Company Profile | Services | Contact Us | SQL scripts and tips | Quiz Legal