RE: set_sql_trace_in

From: Veronica Levin <vlevin_at_victoria.com.ni>
Date: Mon, 8 May 2000 08:26:04 -0600
Message-Id: <10491.105166@fatcity.com>

Hi to all,
I was prefacing it with execute...

I didn't remove any trace file at OS level, becuase there was no trace = file
created....

as I said, it worked fine with other session,

thanks for your comments!

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: Miller, Jay [mailto:JayMiller_at_TDWaterhouse.com] Enviado el: Viernes 5 de Mayo de 2000 1:49 PM Para: Multiple recipients of list ORACLE-L Asunto: RE: set_sql_trace_in_session

Are you prefacing the command with exec? e.g., exec sys.dbms_system.set_sql_trace_in_session(41,2335,TRUE);

-----Original Message-----
Sent: Thursday, May 04, 2000 12:57 PM
To: Multiple recipients of list ORACLE-L

Hi listers,
What script do I have to run to be able to execute=20 sys.dbms_system.set_sql_trace_in_session(41,2335,TRUE)

(as an example)

I used to run this very often, and now I can't generate a trace at = all...=20
I run that sentence and that is it.
No output at all...=20

Anyone willing to help me out?

thanks in advance,

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
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). --=20
Author: Miller, Jay
INET: JayMiller_at_TDWaterhouse.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------