hot lib cache latch identified, how to solve ?

List,

from v$system_event

name		latch free	
total_waits	887103 
total_timeouts	716988
avg_wait	13.5

from v$latch

name		library cache
actual_gets	355803921
misses		306717
spin_gets	150700
sleeps		813136

the lib cache latch has max number of sleeps, but the hit rate is 99 percent !!

looking at the v$latch children for latch 99 i found that latch# 7 has an abnormanlly high number of gets/misses and sleeps when compared against the other library cache latches. Then i ran the script from ixora.com
and identified the sql's associated with this latch # 7.

Most of the sql's are issued from the forms application, i had earlier increased
i had earlier increased the kgl_latch_count to 7 from 5, hoping that more latches
would spread these sql's, the kgl_bucket_count is set to 3 (4093 buckets)

My question is... how can i spread the latch contention evenly across these 7 latches ?
should i add more latches/buckets ?
should i even worry about this ? Received on Wed Nov 22 2000 - 21:52:15 CST