there is a point at which you begin to tune for the sake of tuning and not because you are relieving a problem.
if you are not getting reports of performance problems, why are you trying to fix it? the old adage "if it ain't broke, don't fix it" applies here. --- Denham Eva <[EMAIL PROTECTED]> 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? > > Regards > Denham Eva > Oracle DBA > "UNIX is basically a simple operating system, but you have to be a > genius to > understand the simplicity." > Dennis Ritchie. > > > _____________________________________________________________________________ > DISCLAIMER > This message is for the named person's use only. It may contain > confidential, > proprietary or legally privileged information. No confidentiality > or privilege is waived or lost by any mistransmission. If you receive > > this message in error, please immediately delete it and all copies > of it from your system, destroy any hard copies of it and notify the > sender. You must not, directly or indirectly, use, disclose, > distribute, print, or copy any part of this message if you are not > the intended recipient. TFMC, its holding company, and any of its > subsidiaries each reserve the right to monitor and manage all e-mail > communications through its networks. > > Any views expressed in this message are those of the individual > sender, > except where the message states otherwise and the sender is > authorized > to state them to be the views of any such entity. > ____________________________________________________________________________ > > _____________________________________________________________________________________ > This e-mail message has been scanned for Viruses and Content and > cleared > by MailMarshal > > For more information please visit www.marshalsoftware.com > _____________________________________________________________________________________ > __________________________________________________ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
