RE: WILLING_TO_WAIT_COPY < 1%

From: Gupta, Brijesh <Brijesh.Gupta_at_Airliquide.com>
Date: Wed, 02 May 2001 10:16:39 -0700
Message-ID: <F001.002F77FD.20010502095026@fatcity.com>

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:v.schoen_at_inplan.de] 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:v.schoen_at_inplan.de
http://www.inplan.de

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Schoen Volker
  INET: v.schoen_at_inplan.de

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: ListGuru_at_fatcity.com (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). Received on Wed May 02 2001 - 12:16:39 CDT