Re: How to tell if a Session is being traced

Thanks Jonathan

  The real reason I wanted to be able to query it is I did not want to try and TKPROF the trace file if it is still in use so that TKPROFing will have a closed file to work against. I'm writing a front end tool for easy session tracing and TKPROFing.

Thanks

Jonathan Lewis wrote:

> 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 - 15:04:21 CDT