jump to content

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 > 0