REM  #*****************************************************
REM  # File Name: latch_hit_ratio.sql
REM  #
REM  # Purpose: Reports the latch hit ratios
REM  #
REM  #*****************************************************

column "MISS_RATIO" format 99.99
column "IMMEDIATE_MISS_RATIO" format 99.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#)
order by l.name;