Re: how to set optimizer_index_cost_adj and cache parameters?

From: Tim Gorman <tim_at_sagelogix.com>
Date: Thu, 25 Mar 2004 10:36:50 -0700
Message-ID: <BC8866C2.121D7%tim@sagelogix.com>

Oh, you mean the SPIN_COUNT parameter... :-)

on 3/25/04 8:11 AM, Cary Millsap at cary.millsap_at_hotsos.com wrote:

> I agree. Following the procedure listed below reminds me of how
> difficult it would be to take the lug bolts off a car wheel with the
> wheel spinning at 1000rpm.
>
>
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> * Nullius in verba *
>
> Upcoming events:
> - Performance Diagnosis 101: 3/23 Park City, 4/6 Seattle, 5/7 Dallas
> - SQL Optimization 101: 3/29 Dallas, 4/19 Denver, 5/3 Boston, 5/24 San
> Diego
> - Hotsos Symposium 2005: March 6-10 Dallas
> - Visit www.hotsos.com for schedule details...
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still
> Sent: Thursday, March 25, 2004 9:06 AM
> To: Oracle-L Freelists
> Subject: Re: how to set optimizer_index_cost_adj and cache parameters?
>
> IIRC, the best option is to leave them alone.
>
> Jared
>
> On Thu, 2004-03-25 at 05:23, Juan Cachito Reyes Pacheco wrote:

>> Hi,
>> 
>> After reading a lot about this, this is my conclusion, do you agree?
>> 
>> the conclusion seems to be gather system statics from every distinct

> process

>> or group of process, and set manually this values in every one of

> them.

>> 
>> If this process is by time, for example night and day, you can use

> alter

>> system parameter,
>> if this is only for ap articular process you will have to set alter

> session.

>> 
>> And set the value.
>> This seems to be a hard work.
>> 
>> regards,
>> 
>> 
>> ----------------------------------------------------------------
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> ----------------------------------------------------------------
>> To unsubscribe send email to:  oracle-l-request_at_freelists.org
>> put 'unsubscribe' in the subject line.
>> --
>> Archives are at http://www.freelists.org/archives/oracle-l/
>> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>> -----------------------------------------------------------------

>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Mar 25 2004 - 11:57:39 CST