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: running tkprof on NT?

Re: running tkprof on NT?

From: Vitaliy Mogilevskiy <vit100gain_at_earthlink.net>
Date: Fri, 14 May 1999 23:05:00 -0700
Message-ID: <373D0E8C.BF870CE3@earthlink.net>


You can use this command it worked for me:

DOS> tkprof80 <trace_file_name> <output_file_name> explain=username/password sys=no

+-------------------------------------------------------------+
| Vitaliy Mogilevskiy                                         |
| Senior Consultant                                           |
| CORE Technology Group, Inc.                                 |
| E-mail:    vit100gain_at_earthlink.net                         |
| Fax :      (707) 516-2163                                   |
| Web Page:  http://home.earthlink.net/~vit100gain/index.html |
|            *** Free DBA Script Library at my Web Page ***   |
+-------------------------------------------------------------+


David Spaisman wrote:

> Hello:
>
> I have been trying to run tkprof from the orant\bin directory. I have been
> getting ora 00900 erros whenever I tried running it today.
>
> 1) First I did the alter session set .. in svrmgr30.
>
> 2)from the comand line in oranr\bin I ran the following
> 'tkprof ora00402.trc e:\orant\dtabase051399profa.txt explain=userid/pswd.
>
> Should I have set any sort parameters like (prsela,exeeela,fchela) or left
> the entire parameter out?
>
> What should I pass with explain -- userid/pwsd or the explain file?
>
> The ora-00900 error may have been caused by the rbs tablespace getting low
> on disk space but I fixed that and ran tkprof again(without setting the sql
> traceoff and on again) and got the same result.
>
> Has any one else experienced any problem with tkprof running from the
> command line under NT?
>
> Thanks.
>
> David Spaisman
Received on Sat May 15 1999 - 01:05:00 CDT

Original text of this message

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