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 09:23:45 -0400

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

Other related posts: