I had the same problem. Its shows 56% on 8.0.5 database.
But here is a thought. When I upgraded to 8.1.6 it shows 0%.
I still have one database on 8.0.5 where it shows 57%
Also this parameter LOG_SIMULTANEOUS_COPIES is gone in 8.1.6
Brijesh
-----Original Message-----
From: Schoen Volker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 02, 2001 9:24 AM
To: Multiple recipients of list ORACLE-L
Subject: Q: WILLING_TO_WAIT_COPY < 1%
Hi list,
I have a problem with one of my customers databases. The value of
WILLING_TO_WAIT_COPY = 100. I have read that this value should be smaller
than 1. Parameter LOG_SIMULTANEOUS_COPIES is set to 4 in init.ora. Database
is Oracle 8.0.5 under Windows NT 4.0. Hardware is a 2 CPU machine.
Now my question:
What should I do so that WILLING_TO_WAIT_COPY < 1%?
Here is the select which gives me the values.
SELECT round(a.misses/(a.gets + 0.000001)*100,2) willing_to_wait_copy
FROM v$latch a, v$latchname b
WHERE b.name = 'redo copy' AND b.latch# = a.latch#;
TIA
Regards
Volker Schön
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Schoen Volker
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
