Re: Identify sessions that are currently traced.

From: John K. Hinsdale <hin_at_alma.com>
Date: 30 Jan 2007 11:45:37 -0800
Message-ID: <1170186337.221484.233140@j27g2000cwj.googlegroups.com>

wagen123_at_yahoo.com wrote:

> Even though I started trace (alter session set events '10046 trace
> name context forever, level 12';) through a logon trigger for the user
> XYZ, the gv$session view is not updated.
>
> SQL> select
> sid,serial#,inst_id,SQL_TRACE,SQL_TRACE_WAITS,SQL_TRACE_BINDS from gv
> $session where username='XYZ'

Use "dbms_monitor.session_trace_enable()" instead of "alter session set events ..." and you will see the columns sys.gv_$session updated.

For a quick summary of DBMS_MONITOR usage see: http://www.psoug.org/reference/dbms_monitor.html

HTH John Hinsdale Received on Tue Jan 30 2007 - 13:45:37 CST