Re: SQL trace.

From: Christophe Roux <roux.c_at_ibm.net>
Date: 1996/09/19
Message-ID: <01bba667$679e71e0$443e5c8b_at_ibm.ibm.net>#1/1

You can try :

  dbms_system.set_sql_trace_in_session(SID,SERIAL#,TRUE) to enable tracing in anothe session
  dbms_system.set_sql_trace_in_session(SID,SERIAL#,FALSE) to disable tracing.

Note: 	This must be run as SYS user
	SID and SERIAL# can be found in v$session view.

-- 
Christophe Roux                             e-mail : roux.c_at_ibm.net
CGI Informatique                             http://www.cgi-corp.com

48, Av. G. Motta
CH-1211 Genève - Switzerland

Eugene Freydenzon <efreydenzon_at_corpinfo.com> wrote in article <323F2EB6.2CA0_at_corpinfo.com>...
> I was wondering if somebody knows, how to enable and disable tracing for
> ANOTHER session. DBMS_SQL and DBMS_SESSION work only with current
> session.
> Note: I can not control or change another session (connection included).
>
> Eugene
> --
> ********************************************************
> * Everything above is only my opinion *
> ********************************************************
> * *
> * If you see a lion in a cage and sign says "elephant" *
> * , *
> * DO not belive your eyes ! *
> * (Kozma Prutkov. (informal translation)) *
> * *
> ********************************************************
>
  Received on Thu Sep 19 1996 - 00:00:00 CEST