Re: Identify sessions that are currently traced.

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: 31 Jan 2007 01:17:55 -0800
Message-ID: <1170235075.635205.102070@a75g2000cwd.googlegroups.com>

wagen123_at_yahoo.com wrote:
> 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

See http://www.freelists.org/archives/oracle-l/11-2006/msg00633.html

Gints Plivna
http://www.gplivna.eu Received on Wed Jan 31 2007 - 03:17:55 CST