Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_system.set_sql_trace_in_session(SID,SERIAL#,TRUE) not working

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

From: GC <assistant_madman_at_hotmail.com>
Date: Sun, 17 Dec 2000 01:45:32 GMT
Message-ID: <3A3C1AFF.BEB309A2@hotmail.com> 






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




The synonym may not be created. Try running 'exec
sys.dbms_system.set_sql_trace_in_session(sid,serial#,true)' and see what
happens.



Cheers,


GC
Received on Sat Dec 16 2000 - 19:45:32 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US