Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> how to set optimizer_index_cost_adj and cache parameters?
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,