how to set optimizer_index_cost_adj and cache parameters?

From: Juan Cachito Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Thu, 25 Mar 2004 09:23:45 -0400
Message-ID: <022901c4126c$6da84a10$2501a8c0@dazasoftware.com>

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

---

Received on Thu Mar 25 2004 - 07:46:57 CST