OraFAQ Forum: Server Utilities » tkprof error in command prompt

Home » RDBMS Server » Server Utilities » tkprof error in command prompt

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

tkprof error in command prompt [message #211925]

Wed, 03 January 2007 02:20

ananth.dikshit
Messages: 21
Registered: November 2006
Location: HYD

Junior Member

Hi,

I am using oracle 10g.
I have generated a sql trace file. when i type

tkprof tracefilename.trc outputfile.... in command prompt
then I am getting " could not open tracefile name.trc"
error.

Please help me out to resolve this error

Thanks in advance

Ananth

Report message to a moderator

Re: tkprof error in command prompt [message #211926 is a reply to message #211925]

Wed, 03 January 2007 02:22

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Unix or DOS? Are you in the right directory? Do a directory listing and post the output.

Report message to a moderator

Re: tkprof error in command prompt [message #211927 is a reply to message #211925]

Wed, 03 January 2007 02:26

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi,

E:\>tkprof ded_lgwr_2176.trc e:\trace.txt

TKPROF: Release 10.1.0.2.0 - Production on Wed Jan 3 12:23:58 2007

Copyright (c) 1982, 2004, Oracle.  All rights reserved.


could not open trace file ded_lgwr_2176.trc

E:\>tkprof C:\oracle\product\10.1.0\admin\DED\bdump\ded_lgwr_2176.trc e:\trace.t
xt

TKPROF: Release 10.1.0.2.0 - Production on Wed Jan 3 12:24:16 2007

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

regards
Taj

Report message to a moderator

Re: tkprof error in command prompt [message #211933 is a reply to message #211927]

Wed, 03 January 2007 02:45

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

ded_lgwr_2176.trc looks like a LGWR trace file. TKProf can only analyze SQL Trace files.

Report message to a moderator

Re: tkprof error in command prompt [message #211935 is a reply to message #211933]

Wed, 03 January 2007 02:47

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

ded_lgwr_2176.trc looks like a LGWR trace file. TKProf can only analyze SQL Trace files.

I Know Frank..
i just give example...

[Updated on: Wed, 03 January 2007 02:47]

Report message to a moderator

Re: tkprof error in command prompt [message #211936 is a reply to message #211935]

Wed, 03 January 2007 02:52

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Quote:

E:\>tkprof ded_lgwr_2176.trc e:\trace.txt

...will obviously not work, you are in the wrong directory. Try:

C:
cd C:\oracle\product\10.1.0\admin\DED\bdump
tkprof ded_lgwr_2176.trc e:\trace.txt

Report message to a moderator

Re: tkprof error in command prompt [message #211938 is a reply to message #211936]

Wed, 03 January 2007 02:55

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

I know frank look OP mistake his not give complete path.
on my previous post i was just did wrong step to show mistake.

E:\>tkprof ded_lgwr_2176.trc e:\trace.txt
[I]could not open trace file ded_lgwr_2176.trc[/I]
after that i give complete path name where trace file exists.
E:\>tkprof C:\oracle\product\10.1.0\admin\DED\bdump\ded_lgwr_2176.trc e:\trace.t
xt

regards
Taj

[Updated on: Wed, 03 January 2007 02:55]

Report message to a moderator