Home » SQL & PL/SQL » SQL & PL/SQL » TKPROF
TKPROF [message #186571] Tue, 08 August 2006 09:19 Go to next message
navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA
Senior Member

Hi All,
Its a frequently asked question in the board..
I am not clear about this...So finally decided to post...
I know that to find the execution time and for performance tuning sql_trace and TKPROF is used. Also i searched in net abt this a lot...Still i need some clear inputs from any one of you...

Assume below are the steps i performed to know the execution time of one pl/sql program...
Alter session set sql_trace= true
ALTER SYSTEM SET TIMED_STATISTICS = TRUE;

Executed my pl/sql code

Look for TKPROF



But i dont know where to look for TKPROF output???
Or let me put my question in this way. How to configure such that i can view the output of TKPROF?

Naveen

[Updated on: Tue, 08 August 2006 09:21]

Report message to a moderator

Re: TKPROF [message #186574 is a reply to message #186571] Tue, 08 August 2006 09:56 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
the trace files rea typically written to the "udump" folder located under the "admin" folder.
Re: TKPROF [message #186576 is a reply to message #186571] Tue, 08 August 2006 10:03 Go to previous messageGo to next message
navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA
Senior Member

anacedent,
Thanks for ur reply..

Assume,I have only oracle client installed in my PC,then how can i view the trace files...Is there any method...
FYI, i Logged in to DB using sysdba rights and found the path using below query...

select value 
  from v$parameter 
  where name = 'user_dump_dest';


trace files is in 'E:\oracle\admin\MDWH\udump'

Naveen

[Updated on: Tue, 08 August 2006 10:06]

Report message to a moderator

Re: TKPROF [message #186590 is a reply to message #186576] Tue, 08 August 2006 11:50 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
The trace files are on your SERVER not on the client.
You manually have to execute tkprof on them to get readable output.
Re: TKPROF [message #186672 is a reply to message #186571] Wed, 09 August 2006 00:24 Go to previous messageGo to next message
navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA
Senior Member

Frank,
I do know that the trace files are on the SERVER.
I dont have access to that server.Its located in clients place.
So how can i view the trace file.
Quote:


You manually have to execute tkprof on them to get readable output.



How to perform the above action...It may be a spoon feeding, but still pls help me out...

Naveen
Re: TKPROF [message #186674 is a reply to message #186672] Wed, 09 August 2006 00:30 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
To access the tracefiles maybe this link can help you
Previous Topic: Outer join query blowing away my temp tablespace
Next Topic: Date difference in sql
Goto Forum:
  


Current Time: Tue Dec 06 06:24:08 CST 2016

Total time taken to generate the page: 0.08607 seconds