|
|
abukta
super admin
profile |
|
Join Date: 29 Mar 2005 21:03
Posts: |
|
|
Monitoring Redo Log Status |
The easy way to monitor your redo logs is by looking at V$LOG and V$LOGFILE views. This scripts below selects information about the redo logs. You have to be SYSTEM or use SYSTEM-like account to execute this script:
col Member format a40
col Logstat format a10 heading 'Use Status'
select Member,
a.Group#,
b.Status,
a.Status Logstat
from V$LOGFILE a, V$LOG b
where a.Group#=b.Group#
/
Output (example):
============
MEMBER GROUP# STATUS Use Status
---------------------------------------- ---------- ---------------- ----------
E:\\ORA\\ORADATA\\H881G20J\\LOG01.DBF 1 CURRENT
E:\\ORA\\ORADATA\\H881G20J\\LOG02.DBF 2 INACTIVE
Looking at the output you can tell:
1. the database does not use log mirroring because there is only one log per GROUP#.
2. they are all on the same disk which often results in reduction in preformance.
3. there are 2 logs.
4. log with INACTIVE status means the redo log is not needed for instance recovery.
5. the current and in-use redo log is LOG01.
|
Home 
Forum
