I agree with you Wolfgang, if you are using a third party product, you have
to ask to your vendor before. In the same way you will have to ask him
before change any thing that affect optimizer plan.
But in other database this should be set, the default values are senseless
for most
database.
> -----Original Message-----
> Wolfgang Breitling
>
> 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.
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 04 2004 - 17:32:12 CST
