Re: how to set optimizer_index_cost_adj and cache parameters?

From: Jared Still <jkstill_at_cybcon.com>
Date: Thu, 25 Mar 2004 07:06:03 -0800
Message-Id: <1080227163.1181.17929.camel@poirot>

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
-----------------------------------------------------------------

Received on Thu Mar 25 2004 - 08:58:56 CST