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

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Fri, 15 Dec 2000 19:03:11 GMT
Message-ID: <3a3a6aca.1288719039@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

Received on Fri Dec 15 2000 - 13:03:11 CST