tkprof question [message #57049] |
Fri, 16 May 2003 14:10 |
Sankar B. Mandalika
Messages: 20 Registered: November 2002
|
Junior Member |
|
|
Hi,
I am running tkprof on a slow query. Here is what I am doing.
SQL> alter session set sql_trace=true;
SQL> run query via a script
SQL> quit;
I need to do this from the client as I do not have access to the server. Where would the .trc file be located? And would I have access to the tkprof utility from the client?
Thanks,
Sankar.
|
|
|
|
Re: tkprof question [message #57056 is a reply to message #57049] |
Sat, 17 May 2003 13:27 |
sai sreenivas jeedigunta
Messages: 370 Registered: November 2001
|
Senior Member |
|
|
the trace file is created in the user_dump_dest location.
It will be loacated in the server.
you can normally open the oracleadmindb_nameudump
folder and find the last created file.
with either ls -ltr or in NT u can arrange icons by date
you can open the .trc file with notepad / vi and see if it contains the Query u had given. Once it contains your query that is your trace file.
then use the TKPROF utility as follows.
c:>tkprof <
> <<outputfile>> <<[[explain=Y]]>>
Ex:
c:> tkprof d;oracleadminprinceudumpora08903.trc c:output.txt explain=y
then you can open the c:output.txt and start diagnosing.
sai
|
|
|
Re: tkprof question [message #57057 is a reply to message #57049] |
Sat, 17 May 2003 13:28 |
sai sreenivas jeedigunta
Messages: 370 Registered: November 2001
|
Senior Member |
|
|
the trace file is created in the user_dump_dest location.
It will be loacated in the server.
you can normally open the oracleadmindb_nameudump
folder and find the last created file.
with either ls -ltr or in NT u can arrange icons by date
you can open the .trc file with notepad / vi and see if it contains the Query u had given. Once it contains your query that is your trace file.
then use the TKPROF utility as follows.
c:>tkprof tracefile outputfile [[explain=Y]]
Ex:
c:> tkprof d;oracleadminprinceudumpora08903.trc c:output.txt explain=y
then you can open the c:output.txt and start diagnosing.
sai
|
|
|