RE: set_sql_trace_in

From: Veronica Levin <vlevin_at_victoria.com.ni>
Date: Thu, 4 May 2000 14:36:17 -0600
Message-Id: <10487.104977@fatcity.com>

thanks to all who answered,

I did check that the sid and serial# where correct, and still didn't = get any
output...=20

I tried to trace another session and everything worked fine,

what could have gone wrong with the first one?

TIA!

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

-----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 =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

P.S Don't forget to run again
alter session set sql_trace =3D false
alter system set timed_statistic =3D false

Hope it helps...

--=20
Author:=20
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). Received on Thu May 04 2000 - 15:36:17 CDT

RE: set_sql_trace_in_session