doc

    Name:    liblatch.sql

    Author:  Mark Gurry

    This script shows the library latch contention. The usual cause of 
    the problem is to have the library latch set too small.

#

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