Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: tkprof & explain question
On 5/21/05, amit.poddar_at_yale.edu <amit.poddar_at_yale.edu> wrote:
>
> Agreed
>
> But there is no guarantee that
> the plan showed in explain plan (by using explain=<>) was really used by
> the process.
>
There is no guarantee, that's true, but the number of times the two do not
match is actually quite small. On the other hand I am seeing more and more
occasions where the STAT lines don't get dumped :(
-- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com -- http://www.freelists.org/webpage/oracle-lReceived on Mon May 23 2005 - 07:44:28 CDT
![]() |
![]() |