Ah. If you delete a trace file for a session that is being traced, it won't recreate a new one.
I was probably something like that. Once again, this is from my experience on a select few
versions and platforms. Individual results may vary.
- Veronica Levin <vlevin_at_victoria.com.ni> wrote:
> 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).
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
Received on Thu May 04 2000 - 22:06:44 CDT
