Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to tell if a Session is being traced

How to tell if a Session is being traced

From: Richard Creasey <removespam_creas002_at_mc.duke.edu>
Date: Tue, 15 Jun 1999 14:34:17 -0400
Message-ID: <37669CA9.6F48DB9C@mc.duke.edu> 





Hello All



 Is there a dictionary view of system table that I can query to see if
a given session is currently being traced?



Example. Monday DBA 1 executes :


'exec dbms_system.set_sql_trace_in_session(sid,serial#,TRUE)'
and Tuesday DBA 2 needs to see if anyone turned tracing on for
that session already or should they do it.



Thanks


Richard


creas002_at_mc.duke.edu

Received on Tue Jun 15 1999 - 13:34:17 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US