Re: event 10053 usage

Dikkie Dik wrote:
>
> Even with the whitepaper (with is the best I could found on this topic
> sofar) I have to do lots of things myself. Is there a possibility to get
> things more automated?
>
> "Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message
> news:3EB7CBFB.75C8_at_yahoo.com...
> > Dikkie Dik wrote:
> > >
> > > 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
> >
> > Go to www.hotsos.com - there is a white paper by Wolfgang Breitling
> >
> > hth
> > connor
> > --
> > =========================
> > Connor McDonald
> > http://www.oracledba.co.uk
> >
> > "Some days you're the pigeon, some days you're the statue"

One could argue that optimisation is not really a simple process :-)

Besides playing with explain-plan and 10053 I don't know of any thorough methods for examining the optimiser

cheers
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"