Message-Id: <10589.114482@fatcity.com> From: "Koivu, Lisa" Date: Mon, 14 Aug 2000 07:53:38 -0400 Subject: RE: Turning on trace for active user This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C005E6.48F18F42 Content-Type: text/plain; charset="iso-8859-1" Hi Cherie, this package is owned by sys. Either preface the command with SYS. or run it as SYS. Lisa -----Original Message----- From: Cherie_Machler@gelco.com [mailto:Cherie_Machler@gelco.com] Sent: Friday, August 11, 2000 2:07 PM To: Multiple recipients of list ORACLE-L Subject: Turning on trace for active user We are using Oracle 8.0.4 in a Sun Solaris environment. I am trying to turn on trace for an active session. I am using the following command from a sqlplus prompt within unix on the box where the database is running: EXECUTE dbms_system.set_sql_trace_in_session (44, 36, TRUE); where 44 is the SID and 36 is the serial number of the session to be traced. I get the following error: begin dbms_system.set_sql_trace_in_session (44, 36, TRUE); end; * ERROR at line 1: ORA-06550: line 1, column 7: PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored Can anyone shed light on this error? Do I need to run a CAT? script or something? Am I missing a package? Thanks in advance, Cherie -- Author: INET: Cherie_Machler@gelco.com 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@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). ------_=_NextPart_001_01C005E6.48F18F42 Content-Type: text/html; charset="iso-8859-1" RE: Turning on trace for active user

Hi Cherie,

this package is owned by sys.  Either preface the command with SYS.  or run it as SYS.

Lisa

-----Original Message-----
From: Cherie_Machler@gelco.com [mailto:Cherie_Machler@gelco.com]
Sent: Friday, August 11, 2000 2:07 PM
To: Multiple recipients of list ORACLE-L
Subject: Turning on trace for active user


We are using Oracle 8.0.4 in a Sun Solaris environment.

I am trying to turn on trace for an active session.   I am using the following
command
from a sqlplus prompt within unix on the box where the database is running:

EXECUTE dbms_system.set_sql_trace_in_session (44, 36, TRUE);

where 44 is the SID and 36 is the serial number of the session to be traced.

I get the following error:

begin dbms_system.set_sql_trace_in_session (44, 36, TRUE); end;

      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


Can anyone shed light on this error?  Do I need to run a CAT? script or
something?
Am I missing a package?

Thanks in advance,

Cherie


--
Author:
  INET: Cherie_Machler@gelco.com

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@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).