Eva, just to correct myself from my earlier post it's entirely possible to set _spin_count using ALTER SYSTEM. It may be a sensible measure to try if you're having serious contention issues. Steve Adams has some 'spin_count' scripts that you might find useful at http://www.ixora.com.au/scripts/latches.htm <http://www.ixora.com.au/scripts/latches.htm> Regards, Mike Hately -----Original Message----- Sent: Thursday, November 07, 2002 1:29 PM To: Multiple recipients of list ORACLE-L
Already running on 100% caffeine_level saturation :) Maybe your right, the contention could be elsewhere, the other issue I have been investigating is LGWR process? With increasing the LOG_BUFFER from 512 to a Meg in size, as I have at times very high redo log switch, however they average about 3-4 an hour? Anyway the idea is to keep investigating. Regards Denham -----Original Message----- <mailto:sfaroult@;oriole.com> ] Sent: Thursday, November 07, 2002 1:59 PM To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
