Home » RDBMS Server » Server Utilities » tkprof error in command prompt
tkprof error in command prompt [message #211925] Wed, 03 January 2007 02:20 Go to next message
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
Re: tkprof error in command prompt [message #211926 is a reply to message #211925] Wed, 03 January 2007 02:22 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Unix or DOS? Are you in the right directory? Do a directory listing and post the output.
Re: tkprof error in command prompt [message #211927 is a reply to message #211925] Wed, 03 January 2007 02:26 Go to previous messageGo to next message
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

Re: tkprof error in command prompt [message #211933 is a reply to message #211927] Wed, 03 January 2007 02:45 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
ded_lgwr_2176.trc looks like a LGWR trace file. TKProf can only analyze SQL Trace files.
Re: tkprof error in command prompt [message #211935 is a reply to message #211933] Wed, 03 January 2007 02:47 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Frank Naude
Messages: 4502
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
Re: tkprof error in command prompt [message #211938 is a reply to message #211936] Wed, 03 January 2007 02:55 Go to previous messageGo to next message
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

Re: tkprof error in command prompt [message #211939 is a reply to message #211938] Wed, 03 January 2007 02:59 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Oops, sorry. I thought you posted the original issue.
Re: tkprof error in command prompt [message #211941 is a reply to message #211939] Wed, 03 January 2007 03:01 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

No problem....Wink

regards
Taj

Previous Topic: Bad File not creating
Next Topic: impdp aborting
Goto Forum:
  


Current Time: Sat Dec 03 01:19:03 CST 2016

Total time taken to generate the page: 0.07071 seconds