Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: event 10053 usage
One little trick I use as a quick extract is to grep for lines starting
"Join order"
"Best so far"
The join order lists tables by table name, so
you can see when an order you expected
did not survive (or did not reach) the CBO's
processing.
The "Best so far" appear only when the
CBO has decided that the most recent
join order has a plan better than the previous
best, so you can quickly check the evolution
of the plan.
-- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html ____Denmark__May 21-23rd ____Sweden___June ____Finland__September ____Norway___September Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html ____UK_(Manchester)_May x 2 ____Estonia___June 4th - 6th ____Australia_June 18th - 20th (Perth) ____Australia_June 23rd - 25th (t.b.a) ____USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html "Dikkie Dik" <dwesteneng_at_mail.com> wrote in message news:b98hhd$gii49$1_at_ID-154318.news.dfncis.de...Received on Sat May 10 2003 - 03:29:34 CDT
> Hi,
>
> I sometimes have to go throught 10053 output to find why Oracle
ignores my
> hint or thinks it is smarter than me. Is there any tool to make this
output
> less complicated so I easily can find what to change so Oracle
solves it as
> I think it should do so?
>
> Thanks in advance,
> Dick
>
>