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

From: <ashish25_at_my-deja.com>
Date: Fri, 15 Dec 2000 19:49:46 GMT
Message-ID: <91dskm$erb$1@nnrp1.deja.com>

Hi,

   Try
  execute dbms_system.set_sql_trace_in_session(SID,SERIAL#,TRUE)     to start the trace
  and
  execute dbms_system.set_sql_trace_in_session(SID,SERIAL#,FALSE)

  to stop the trace

Thanks,
Ashish
In article <3a3a6aca.1288719039_at_news.earthlink.net>,   andreyNSPAM_at_bookexchange.net (NetComrade) wrote:
> 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
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Dec 15 2000 - 13:49:46 CST