We have a database that has started to experience SEVERE spikes in Latch Waits (library cache). These spikes are in the range of 100K - 1M ms waited/sec. When the spikes occur, our users are almost completely locked-up until the latches come down.
Most of the documentation on Library Cache Latches tells you to tune your SQL. Unfortunately, this is a purchased application, and we have no ability to change the sql.
A couple of notes on our database:
-The database has ~80 Gb of data
-We have ~800 users on a typical day... using the same application for the most part.
-Our system is 8.1.6.3 on AIX 4.3.3
-We have 16 Gb of Memory
-Our SGA is ~3 Gig
-We are using MTS.
Does anyone have any idea what we can do to fix this problem?
Any help would be appreciated!
Thanks!
Jodie