I have to admit that I am not a fan of changing them from their default
values. In the databases I am, or have been, working with (Peoplesoft),
changing them usually induces too many NL joins with disastrous consequences.
In Oracle 9i I would investigate the use of dbms_stats.gather_system_stats
prior to attempting to tweak the O_I_C.. parameters. Joze Senegacnik
reports good success with it. I myself do not have experience with 9i in a
large enough production setting to say.
At 10:32 AM 3/4/2004, you wrote:
I am trying to determine if setting the two spfile parameters "optimizer_index_caching" and "optimizer_index_cost_adj" to values of other than the default does actually enhance or degrade the SQL queries.
So my questions are 1. Do you set these parameters ?? 2. If you do what values work for you ?? 3. What do you do in a case where it works for most but not for all of your SQL??
TIA.
Yuval.
---------------------------------------------------------------- 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 -----------------------------------------------------------------