How to tune Latches??
DaljitJul 25 2006 — edited Jul 27 2006I found my system very slow today and these are the top 5 events from statspack report:
Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
latch: library cache 29,279 55,856 1,908 35.2 Concurrency
enq: TX - row lock contention 20,601 54,485 2,645 34.3 Application
latch free 6,216 16,632 2,676 10.5 Other
latch: shared pool 15,164 15,714 1,036 9.9 Concurrency
log file sync 103,734 7,578 73 4.8 Commit
I want to know how to tune latches in 10g R2.
This one is on 10.2.0.2@Linux.
Any pointers will be helpfull.
Daljit Singh