happened to me once.... had to exit/connect again and
issue the set trace command, workes fine this way...
> ----------
> From: Veronica Levin[SMTP:vlevin_at_victoria.com.ni]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: 05 Mei 2000 04:39
> To: Multiple recipients of list ORACLE-L
> Subject: RE: set_sql_trace_in_session
>=20
> thanks to all who answered,
>=20
> I did check that the sid and serial# where correct, and still didn't =
get any
> output...=20
>=20
> I tried to trace another session and everything worked fine,
>=20
> what could have gone wrong with the first one?
>=20
> TIA!
>=20
> **************************************************
> Ver> =F3nica Levin Enriquez
> Administrador AIX
> Compa=F1=EDa Cervecera de Nicaragua
> Tel=E9fono: 505-2493779
> Fax: 505-2443979
> Email: vlevin_at_victoria.com.ni=20
> http://victoria.com.ni
> **************************************************
>=20
>=20
> -----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
>=20
>=20
>=20
>=20
> Try this :
> alter session set sql_trace =3D true
> alter system set timed_statistic =3D true
> After that execute =
dbms_system.set_sql_trace_in_session(sid,serial#,true);
> .................
> run tkprof to interprate you dump
>=20
> P.S Don't forget to run again
> alter session set sql_trace =3D false
> alter system set timed_statistic =3D false
>=20
> Hope it helps...
>=20
>=20
> --=20
> Author:=20
> INET: IlicR_at_stentor.ca
>=20
> 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).
> --=20
> Author: Veronica Levin
> INET: vlevin_at_victoria.com.ni
>=20
> 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
Received on Thu May 04 2000 - 23:06:57 CDT
