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