I am running Oracle 8.1.5 on Solaris 2.6 with a 2 GB SGA (1.4 GB buffer
cache). At intermittent times, my misses and waits for my cache buffer
chains latch goes from 10% to 90% and stays there for 30-40 minutes and then
drops again. During this time, my site performance goes way down as overall
database waits skyrocket. There doesn't seem to be any coorelation between
the spike and extra users, different SQL, etc. I have set
db_block_lru_latches=2048. Is this too high or low?
Also, and maybe related, if I don't purge my 450 MB shared pool every half
hour, the shared pool latch waits go from 10% to 90% also. To prevent this,
I have written a script which does a purge automatically, but this is
obviously less than ideal. What could be causing this? It is as if the
latch can't keep up with the SQL in the shared_pool. I am just confused as
to what is happening here. Any help would be greatly appreciated.
Received on Tue Jun 13 2000 - 18:43:05 CDT
