> Denham Eva wrote: > > Hello Guru's > > I have run a script which indicates that of the three redo log latches > two had occurences of sleeps. To overcome this usually you increase > SPIN_COUNT by 50% or so. > > When trying to ALTER SYSTEM SET SPIN_COUNT = 3000; > Present system is set as 2000. I get the following error. > * > ERROR at line 1: > ORA-25138: SPIN_COUNT initialization parameter has been made obsolete > > Now what? what can I do to overcome the sleeps issues? >
Increase caffeine_level. Seriously, is it a problem? A real bottleneck? You should begin to worry if you do not have worse contention elsewhere. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).
