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 Not Working

Re: tkprof Not Working

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 17 Apr 2004 04:39:43 +1000
Message-ID: <40802873$0$12481$afc38c87@news.optusnet.com.au>


Susanth Sivaram wrote:
> Hi,
> I was trying to trace a on how the query works, and i tried tkprof. It says
> "SP2-0042: unknown command "tkprof" - rest of line ignored."
> I had alter the session for sql_trace=true.
>
> Is there any component to be installed inorder to tkprof to work??
> Pls help.
>
> Thanks,
> Susanth.

Try not to run tkprof within SQL*Plus. It's a standalone utility, so it needs to be run from the command line.

IE,

c:\> tkprof source.trc output.txt

NOT SQL> tkprof ....

Regards
HJR Received on Fri Apr 16 2004 - 13:39:43 CDT

Original text of this message

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