Re: Tracing sessions

From: Mladen Gogala <mgogala_at_verizon.net>
Date: Mon, 30 Oct 2006 21:08:05 -0500
Message-id: <1162260485l.2965l.0l@medo.noip.com>

On 10/30/2006 03:10:09 AM, Polarski, Bernard wrote:

> I did find thing only in 10gR2, it is not in 10.1.0.4.

>
>

Not only is it present only in 10.2.0, it doesn't work. I tried it on Linux, with different methods, from DBMS_MONITOR, set events to set sql_trace, I was always getting the value of 'DISABLED' in SQL_TRACE.

SQL> select sql_trace from v$session where username='SCOTT';

SQL_TRAC

---

DISABLED
DISABLED
DISABLED SQL> / SQL_TRAC

---

DISABLED
DISABLED
DISABLED

SQL>
SQL>
SQL> /

SQL_TRAC

---

DISABLED
DISABLED
DISABLED SQL>

-- 
Mladen Gogala
http://www.mladen-gogala.com

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 30 2006 - 20:08:05 CST