Session Trace file Location - Oracle 12c [message #666966] |
Mon, 04 December 2017 01:59  |
 |
muthukrish104
Messages: 75 Registered: November 2017
|
Member |
|
|
Hi,
I am tracing an another session, but the trace file is not getting generated.
Here is the steps I had followed.
Checking Parameter:
-------------------
select * from v$statistics_level
where
statistics_name = 'Timed Statistics'
Result is == Typical
Searching Session Details:
-------------------------
select username, sid,serial#,osuser,machine from v$session
order by 1
Start Tracing:
--------------
EXEC DBMS_SYSTEM.set_sql_trace_in_session(sid=>1432, serial#=>41755, sql_trace=>TRUE);
At this stage the user started working.
Then I did disable the Trace by:
EXEC DBMS_SYSTEM.set_sql_trace_in_session(sid=>1432, serial#=>41755, sql_trace=>FALSE);
When I queried the below one to find out the location of the trace file, it shows some path.
But physically, there is no trace file got generated.
SELECT p.tracefile
FROM v$session s
JOIN v$process p ON s.paddr = p.addr
WHERE s.sid = 1432;
Why,kindly correct,where I am wrong?.
Regards
Muthu Krish
|
|
|
|
|
|