REM ************************************************************************
REM Filename:	Latches.sql    
REM Description:
REM 	Procedure reports on chained Rows.
REM Comments:
REM
REM Modifications:
REM Author		Date	  Reason
REM Darryl B. Smith	09/01/97  Created
REM ************************************************************************
prompt if miss_ratio or immediate_miss_ratio > 1 then latch 
prompt contention exists, decrease LOG_SMALL_ENTRY_MAX_SIZE in init.ora 
column "miss_ratio" format .99 
column "immediate_miss_ratio" format .99 
select substr(l.name,1,30) name, 
	(misses/(gets+.001))*100 "miss_ratio", 
	(immediate_misses/(immediate_gets+.001))*100 
		"immediate_miss_ratio" 
	from v$latch l, v$latchname ln 
	where l.latch# = ln.latch# 
	and ((misses/(gets+.001))*100 > .2 
            or 
            (immediate_misses/(immediate_gets+.001))*100 > .2) 
order by l.name;