|
| Monday, August 3, 2009 |
| Redo Log Buffer |
Redo Log Buffer
Here are some scripts related to Redo Log Buffer .
Contention
REDO LOG CONTENTION NOTES:
Redo Latch Name - Name of the latch
Gets - Number of times gotten wait
Misses - Number of times gotten wait but failed first try
Sleeps - Number of times slept when wanted wait
Immediate Gets - Number of times gotten without wait
Immediate Misses - Number of times failed to get without wait
Heavy access to the redo log buffer can result in contention for redo log prompt buffer latches.
select NAME,
GETS,
MISSES,
SLEEPS,
IMMEDIATE_GETS,
IMMEDIATE_MISSES
from v$latch
where NAME in ('redo allocation','redo copy')
Statistics
REDO BUFFER NOTES:
Parameter - Name of the parameter
Value - Current value for the parameter
select NAME,
VALUE
from v$sysstat
where NAME like 'redo%'
and VALUE > 0Labels: Redo Log Buffer |
posted by Srinivasan .R @ 11:24 PM  |
|
|
|
|
|
