Re: Tracing sessions
- From: Mladen Gogala <mgogala@xxxxxxxxxxx>
- To: Bernard.Polarski@xxxxxxxxxxxxxx
- Date: Mon, 30 Oct 2006 21:08:05 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
