Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: EXPLAIN PLAN
There is a problem with the cbo in 7.3.4.0 that may have hit you. It comes in
with complex joins using many tables and causes the optimizer to search way too
long. Contact oracle support for an event # and level # to limit the optimizers
search time. I don't remember them any more.
On Fri, 12 Mar 1999 23:36:58 +0100, Jonathan Lewis wrote
(in message <921278309.12735.0.nnrp-12.9e984b29_at_news.demon.co.uk>):
>
> Try:
>
> alter session set events '10053 trace name context forever , level 12';
snip
> optimiser something like: 10! x 3 ^ 10 x 3 ^ 10 possible execution paths
> - and that is a very, very big number - even allowing for the optimiser
> cutting out huge fractions by optimistic analysis (a.k.a. guesswork).
>
--
Ronald.