Re: How to tune SQL to avoid ORA-03232 ?

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Wed, 16 Oct 2002 13:02:01 +0200
Message-ID: <aojh24$e8t$2@ctb-nnrp2.saix.net>

Jan Gelbrich wrote:

> I may not post the Execution Plan,
> because it is far too long to be realistic (5000++ lines !) - something
> strange must have happend to my PLAN_TABLE...

Check your join criteria for the explain plan. I'm lazy when it comes to the plan table and only join on statement id as I always use (or try to) unique ones. However, that is not enforced by Oracle. Having one or two explain plans with the same statement id and doing the join on id only.. very messy. :-)

--
Billy

Received on Wed Oct 16 2002 - 06:02:01 CDT