doc

    Name:    buflatch.sql

    Author:  Mark Gurry

    This script shows the latch contention on the Oracle Buffer Cache.
    Be sure to take adavantage of the mutiple LRU latches by setting the
    DB_BLOCK_LRU_LATCHES parameter if you are using Oracle7.3 or later. 

#

ttitle 'Oracle Buffer Cache Latch Contention'

select substr(name,1,25), gets, misses,
         immediate_gets, immediate_misses 
  from v$latch 
 where misses > 0 or immediate_misses > 0
   and name like ‘cache bu%’
/