Re: Analyze schema, how to unanalyze it? It is halting the database..

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Fri, 24 Aug 2001 10:56:12 GMT
Message-ID: <3b862fca.3721194@news>

On Thu, 23 Aug 2001 17:08:26 -0400, "Unmesh" <unmesh_at_thinking-minds.com> wrote:

>didn't run in TST. HEre is the SQL ..
>

hehehe! Nothing like Peoplesoft to stretch the optimizer of *any* database...

Seriously:

Run an analyze_schema with the DELETE option before you run the other one. And run them both, in both databases. Also, make sure the init.ora is similar between the two instances. There are some parameters there that greatly affect how the optimizer works with large statements. Such as the ones used all over the place in PS applications.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Fri Aug 24 2001 - 05:56:12 CDT