Re: Tuning 9i Database - after migrating from 8i. -
- From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 4 Mar 2004 17:50:59 -0400
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@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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
