Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: event 10053 usage

Re: event 10053 usage

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 10 May 2003 09:29:34 +0100
Message-ID: <b9id80$cpv$1$8300dec7@news.demon.co.uk>

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...

> 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
>
>
Received on Sat May 10 2003 - 03:29:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US