Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: set_sql_trace_in_session

RE: set_sql_trace_in_session

From: Miller, Jay <JayMiller_at_TDWaterhouse.com>
Date: Thu, 4 May 2000 16:11:45 -0400
Message-Id: <10488.105102@fatcity.com>


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

-----Original Message-----
From: Veronica Levin [mailto:vlevin_at_victoria.com.ni] Sent: Thursday, May 04, 2000 12:57 PM
To: Multiple recipients of list ORACLE-L Subject: set_sql_trace_in_session

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). Received on Thu May 04 2000 - 15:11:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US