Re: dbms_system.set_sql_trace_in_session(SID,SERIAL#,TRUE) not working

This may sound daft, but what are you trying to achieve with

    execute dbms_system.set_sql_trace_in_session(SID,SERIAL#,FALSE);

Your first two examples are about turning SQL_trace on, this one is about turning it off. Are you trying to tell us that it doesn't turn sql_trace off when you've used a different method to turn it on, or are you expecting this to turn sql_trace on ?

Apologies if you already knew this but:

    execute dbms_system.set_sql_trace_in_session(SID,SERIAL#,TRUE); to turn it on

    execute dbms_system.set_sql_trace_in_session(SID,SERIAL#,FALSE); to turn it off

If it's not working, it may simply be a version dependent bug.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



NetComrade wrote in message <3a3a6aca.1288719039_at_news.earthlink.net>...


>if I set sql_trace on system level, it works

>if i use ALTER SESSION SET SQL_TRACE=TRUE, it works

>if I 'execute dbms_system.set_sql_trace_in_session(SID,SERIAL#,FALSE)'

>it doesn't

>

>

>OWNER                          OBJECT_NAME

>OBJECT_TYPE        STATUS

>------------------------------

>---------------------------------------------------------------------------

 -----------------------------------------------------


>------------------ -------

>SYS                            DBMS_SYSTEM

>PACKAGE            VALID

>SYS                            DBMS_SYSTEM

>PACKAGE BODY       VALID

>

>Any ideas?

>

>thanx.

>---------------

>In case I forgot to mention:

>We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes

>---------------

>Andrey Dmitriev eFax: (978) 383-5892  Daytime: (917) 750-3630

>AOL: NetComrade ICQ: 11340726 remove NSPAM to email