Re: SHOULD WE ANALYZE 9.2 SYS tables?

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Fri, 30 Jul 2004 02:21:27 +0300
Message-ID: <023b01c475c2$c6489fd0$36ae9fd9@porgand>

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_at_naturaljoin.nl> To: <oracle-l_at_freelists.org> 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_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 Jul 29 2004 - 18:17:58 CDT