RE: Redo Copy Latch MISSES

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Fri, 12 May 2000 19:56:40 +1000
Message-Id: <10495.105481@fatcity.com>

Hi Stuart,

This is not a problem.
Please see the tip on "Redo Latch Tuning" on my web site.

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/


-----Original Message-----
From:	Stuart Houlston [SMTP:Stuart.Houlston_at_bmw.co.uk]
Sent:	Thursday, May 11, 2000 8:24 PM
To:	Multiple recipients of list ORACLE-L
Subject:	Redo Copy Latch MISSES

I have read some conflicting advice and need some clarification from the list.

I currently achieve a REDO COPY LATCH miss rate of approximately 0.94%, I believe that this number is too high and I should be trying to achieve about 0.01%.

My understanding was that the LOG_SIMULTANEOUS_COPIES should be set to the number of processors in the machine (currently two). However I have just read that it should be set to 2*No of CPU's.

Does any one have an opinion on this and also what else can be done to resolve this latch contention?

The system is an Oracle 8.0.5 instance running on a NT.

Thanks

Stuart

---

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager.

This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com

---

-- 
Author: Stuart Houlston
  INET: Stuart.Houlston_at_bmw.co.uk

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 Fri May 12 2000 - 04:56:40 CDT