Re: SHOULD WE ANALYZE 9.2 SYS tables?

I think at least some of the performance problems which have occurred after
analyzing DD, are caused by the usual migration-to-CBO problems, such as
incorrect optimizer_* parameters, etc..

Tanel.



----- Original Message ----- 
From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, July 29, 2004 10:31 PM
Subject: RE: SHOULD WE ANALYZE 9.2 SYS tables?


> Hi Michael,
> thanks for disagreeing with me ;-)
> is this an apps environment, by any chance?


----------------------------------------------------------------
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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: