Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: how to set optimizer_index_cost_adj and cache parameters?
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
> -----------------------------------------------------------------
-- 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 - 09:14:04 CST
![]() |
![]() |