Re: set_sql_trace_in_session

From: A. Bardeen <abardeen_at_hotmail.com>
Date: Thu, 04 May 2000 13:28:20 EDT
Message-Id: <10487.104949@fatcity.com>

Veronica,

This package is created by catproc, actually one of the scripts called by catproc. You would get an error, however, if the package was invalid or there was a permissions issue.

I just tested this on my system and if the sid and serial# are not a valid combination an error message is not returned, just the standard "statement processed".

Have you tested it with your current session info?   SELECT SID,SERIAL# FROM V$SESSION WHERE AUDSID=USERENV('SESSIONID'); HTH,

• Anita

>From: Veronica Levin <vlevin_at_victoria.com.ni>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: set_sql_trace_in_session
>Date: Thu, 04 May 2000 08:57:04 -0800
>
>Hi listers,
>What script do I have to run to be able to execute
>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...
>I run that sentence and that is it.
>No output at all...
>
>Anyone willing to help me out?
>
>thanks in advance,
>
>**************************************************
>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
>**************************************************
>
>--
>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).

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com Received on Thu May 04 2000 - 12:28:20 CDT