Re: how to set optimizer_index_cost_adj and cache parameters?
- From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Mar 2004 11:34:47 -0400
I had to set this parameters several times, so that solutions( leave them
alone) didn't work for me
----- Original Message -----
From: "Jared Still" <jkstill@xxxxxxxxxx>
To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, March 25, 2004 11:06 AM
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@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
