| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_gelco.com [mailto:Cherie_Machler_at_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_at_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_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). ------_=_NextPart_001_01C005E6.48F18F42 Content-Type: text/html; charset="iso-8859-1"Received on Mon Aug 14 2000 - 06:53:38 CDT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12">
<TITLE>RE: Turning on trace for active user</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Hi Cherie, </FONT>
</P>
<P><FONT SIZE=2>this package is owned by sys. Either preface the command with SYS. or run it as SYS.</FONT>
</P>
<P><FONT SIZE=2>Lisa</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Cherie_Machler_at_gelco.com [<A HREF="mailto:Cherie_Machler_at_gelco.com">mailto:Cherie_Machler_at_gelco.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Friday, August 11, 2000 2:07 PM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: Turning on trace for active user</FONT>
</P>
<BR>
<P><FONT SIZE=2>We are using Oracle 8.0.4 in a Sun Solaris environment.</FONT>
</P>
<P><FONT SIZE=2>I am trying to turn on trace for an active session. I am using the following</FONT>
<BR><FONT SIZE=2>command</FONT>
<BR><FONT SIZE=2>from a sqlplus prompt within unix on the box where the database is running:</FONT>
</P>
<P><FONT SIZE=2>EXECUTE dbms_system.set_sql_trace_in_session (44, 36, TRUE);</FONT>
</P>
<P><FONT SIZE=2>where 44 is the SID and 36 is the serial number of the session to be traced.</FONT>
</P>
<P><FONT SIZE=2>I get the following error:</FONT>
</P>
<P><FONT SIZE=2>begin dbms_system.set_sql_trace_in_session (44, 36, TRUE); end;</FONT>
</P>
<P><FONT SIZE=2> *</FONT>
<BR><FONT SIZE=2>ERROR at line 1:</FONT>
<BR><FONT SIZE=2>ORA-06550: line 1, column 7:</FONT>
<BR><FONT SIZE=2>PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared</FONT>
<BR><FONT SIZE=2>ORA-06550: line 1, column 7:</FONT>
<BR><FONT SIZE=2>PL/SQL: Statement ignored</FONT>
</P>
<BR>
<P><FONT SIZE=2>Can anyone shed light on this error? Do I need to run a CAT? script or</FONT>
<BR><FONT SIZE=2>something?</FONT>
<BR><FONT SIZE=2>Am I missing a package?</FONT>
</P>
<P><FONT SIZE=2>Thanks in advance,</FONT>
</P>
<P><FONT SIZE=2>Cherie</FONT>
</P>
<BR>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: </FONT>
<BR><FONT SIZE=2> INET: Cherie_Machler_at_gelco.com</FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from). You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT>
 |
 |