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_at_cybcon.com>
To: "Oracle-L Freelists" <oracle-l_at_freelists.org>
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_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 - 09:52:05 CST
