Problem while TKprof [message #395707] |
Thu, 02 April 2009 06:28 |
sr_orcl
Messages: 82 Registered: January 2009 Location: mumbai
|
Member |
|
|
Hi To All,
I have probelm while generating the trace file .The steps I used as given as below ,
Please Let me know where I am doing wrong.
My Trace file is not generating.
1.
set timing on;
alter session set timed_statistics = true;
alter session set events '10046 trace name context forever, level 12';
alter session set events '10046 trace name context off ';
2.Goto FileZilla
-Connect to the Oracle.
-Then Put the above path found in step1.
-Copy the given trace file in the required path.
3.Run the tkprof.To convert Trace .trc file into .Txt file.
4.TKPROF D:\<Trace_FIle_Name> D:\<Txt_FIle_Name>.txt sys=no explain=test/test@test.com;
To Find out sessionID i used follwoing ,
5.SELECT s.sid,
s.serial#,
pa.value || '/' || LOWER(SYS_CONTEXT('userenv','instance_name')) ||
'_ora_' || p.spid || '.trc' AS trace_file
FROM v$session s,
v$process p,
v$parameter pa
WHERE pa.name = 'user_dump_dest'
AND s.paddr = p.addr
AND s.audsid = SYS_CONTEXT('USERENV', 'SESSIONID');
|
|
|
|
|
|
|