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 <EvaD_at_TFMC.co.za> 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: wisernet100_at_yahoo.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).
Received on Thu Nov 07 2002 - 07:18:27 CST
