Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tkprof output question
"Yaakov Berkovitch" <jaakovb_at_corrigent.com> wrote in message
news:co4eis$ec3$1_at_news2.netvision.net.il...
> Hello,
>
> To those that have experience using the 'alter session sql_trace=true' and
> the tkprof, I have
> a simlpe question.
>
> If I saw in the ouptut generated by tkprof,
> Rows Row Source Operation
> ------- -----------------------------------------------------
> 672 TABLE ACCESS FULL OBJ#(6817)
>
> is that says that the SQL request doesn't use the index ?
Yes, but see below.
> Thanks for any tips.
If the explain plan is generated by the explain=userid/password then the plan shown in the output is not guaranteed to be the actual plan that was executed. In you case (because you don't have an object name) I don't believe you did this, and so you have the real plan which is in the trace file. (lines that start STAT ..)
-- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.comReceived on Thu Nov 25 2004 - 06:40:02 CST