Re: 10053 Interpretation....

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 30 Mar 2006 09:29:22 +0100
Message-ID: <Fs6dneKF58J3C7bZnZ2dnUVZ8qCdnZ2d@bt.com>

<mccmx_at_hotmail.com> wrote in message
news:1143702550.387365.248010_at_j33g2000cwa.googlegroups.com...
> Hi Jonathan,
>
> Are you suggesting that the statistics are incorrect for the
> PS_TL_PAYABLE_TIME table..?
>
> Matt
>

No.

At the moment I'm suggesting that there's something in the trace file I don't understand.

That's why I had to give you the hand-waving mechanical explanation without being able to give you the trace file numbers that show Oracle deriving the same thing.

-- 
Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

Received on Thu Mar 30 2006 - 02:29:22 CST