RE: set_sql_trace_in_session

Veronica,

By any chance was that session already being traced and the trace file removed at the OS level? If so, Oracle won't create another trace file, at least not on most Unix systems, for that session.

That's the only reason I can think of.

Comments and corrections welcome, of course.

• Anita

>From: Veronica Levin <vlevin_at_victoria.com.ni>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: set_sql_trace_in_session
>Date: Thu, 04 May 2000 13:39:17 -0800
>
>thanks to all who answered,
>
>I did check that the sid and serial# where correct, and still didn't get
>any
>output...
>
>I tried to trace another session and everything worked fine,
>
>what could have gone wrong with the first one?
>
>TIA!
>
>**************************************************
>Versnica Levin Enriquez
>Administrador AIX
>Compaqma Cervecera de Nicaragua
>Telifono: 505-2493779
>Fax: 505-2443979
>Email: vlevin_at_victoria.com.ni
>http://victoria.com.ni
>**************************************************
>
>
>-----Mensaje original-----
>De: IlicR_at_stentor.ca [mailto:IlicR_at_stentor.ca]
>Enviado el: Jueves 4 de Mayo de 2000 12:46 PM
>Para: Multiple recipients of list ORACLE-L
>Asunto: Re: set_sql_trace_in_session
>
>
>
>
>Try this :
>alter session set sql_trace = true
>alter system set timed_statistic = true
>After that execute dbms_system.set_sql_trace_in_session(sid,serial#,true);
>.................
>run tkprof to interprate you dump
>
>P.S Don't forget to run again
>alter session set sql_trace = false
>alter system set timed_statistic = false
>
>Hope it helps...
>
>
>--
>Author:
> INET: IlicR_at_stentor.ca
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Author: Veronica Levin
> INET: vlevin_at_victoria.com.ni
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).