Q: WILLING_TO_WAIT_COPY < 1%

From: Schoen Volker <v.schoen_at_inplan.de>
Date: Wed, 02 May 2001 09:00:48 -0700
Message-ID: <F001.002F7223.20010502062422@fatcity.com>

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 - 11:00:48 CDT