Re: How to tell if a Session is being traced

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 15 Jun 1999 20:07:55 +0100
Message-ID: <929473911.14343.0.nnrp-04.9e984b29@news.demon.co.uk>

There is no dictionary view (up to 8.0.5, haven't checked 8.1.5), but if a session is tracing it won't hurt for dba2 to turn it on again anyway, so in this case there seems to be little point in checking.

If you want to a process to check itself to see if it is tracing then there is a method on my website for doing this

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Richard Creasey wrote in message <37669CA9.6F48DB9C_at_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 - 14:07:55 CDT