SQL Script Monitor Redo Logs

Updated: 29-Mar-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

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

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

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links