Home » RDBMS Server » Performance Tuning » Session Trace file Location - Oracle 12c (oracle 12c Windows 2012)
Session Trace file Location - Oracle 12c [message #666966] Mon, 04 December 2017 01:59 Go to next message
muthukrish104
Messages: 82
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
Re: Session Trace file Location - Oracle 12c [message #666968 is a reply to message #666966] Mon, 04 December 2017 02:11 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
dbms_system is not (and never has been) a supported package. What happens if you use dbms_monitor instead?
Re: Session Trace file Location - Oracle 12c [message #666974 is a reply to message #666968] Mon, 04 December 2017 03:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

In addition, NEVER use SYS for something that can be done by another account.
Read SYS is special.

Re: Session Trace file Location - Oracle 12c [message #666975 is a reply to message #666974] Mon, 04 December 2017 03:24 Go to previous message
muthukrish104
Messages: 82
Registered: November 2017
Member
Hi,

Thanks for both of you, I will check out this.

Regards
M.Krish
Previous Topic: Undo tablespace(monitoring and avoiding ORA-01555
Next Topic: Running out of 64gb Temp Space
Goto Forum:
  


Current Time: Fri Mar 29 03:35:55 CDT 2024