Identify sessions that are currently traced.

From: <wagen123_at_yahoo.com>
Date: 30 Jan 2007 11:19:50 -0800
Message-ID: <1170184789.934517.18310@l53g2000cwa.googlegroups.com>

Oracle10g 10.2.0.x 3-node RAC (64 bit)
RHEL AS 4.4 (64 bit)

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'

SID SERIAL# INST_ID SQL_TRAC SQL_T SQL_T ---------- ---------- ---------- -------- ----- -----

1047 34 1 DISABLED FALSE FALSE Appreciate any input/pointers.

Thank You Received on Tue Jan 30 2007 - 13:19:50 CST