Redo copy latch contention

From: Michel Gauthier <qgmi1_at_clic.net>
Date: Tue, 07 Dec 1999 17:10:56 GMT
Message-ID: <Acb34.23186$0c2.273425@carnaval.risq.qc.ca>

I use to monitor latches to see if there are some contention on some of them. I can say that I'm proud of my database settings because, latches wait ratios (misses divided by the gets) are almost all 0%, and when not, they're less than 0.1 %... except for only ONE. The redo copy latch wait ratio is always greater than 80% !!! And I simply don't know why. I set up the log_simultaneous_copies to 6 (that is twice the number of CPUs of our computer) as recommended. Does someone have a suggestion?

Michel Gauthier
Donohue Inc.

(we run release 7.3.2 on a HP3000 MPE 5.5) Received on Tue Dec 07 1999 - 11:10:56 CST