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).
