RE: SPIN_COUNT - 8i obsolete? What now?

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_at_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: Mike.Hately_at_npowernorthern.com

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