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-l
Received on Mon May 23 2005 - 07:44:28 CDT
