Re: tkprof & explain question
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: amit.poddar@xxxxxxxx
- Date: Mon, 23 May 2005 12:39:44 +0100
On 5/21/05, amit.poddar@xxxxxxxx <amit.poddar@xxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
