Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tkprof output question

Re: Tkprof output question

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Thu, 25 Nov 2004 12:40:02 -0000
Message-ID: <41a5d29e$0$1558$cc9e4d1f@news-text.dial.pipex.com>


"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.com 
Received on Thu Nov 25 2004 - 06:40:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US