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

Home -> Community -> Mailing Lists -> Oracle-L -> Turning on trace for active user

Turning on trace for active user

From: <Cherie_Machler_at_gelco.com>
Date: Fri, 11 Aug 2000 12:25:59 -0500
Message-Id: <10586.114386@fatcity.com>


Never mind. I looked it up in metalink (should have done that before I posted) and found out I needed to run prvtutil.plb script which is located in $ORACLE_HOME/rdbms/admin (as SYS).

Thanks anyways,

Cherie

---------------------- Forwarded by Cherie Machler/GELCO on 08/11/2000 01:30 PM
---------------------------


Cherie Machler
08/11/2000 11:54 AM

To: ORACLE-L_at_fatcity.com
cc:

Subject: Turning on trace for active user (Document link: Cherie Machler)

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? Received on Fri Aug 11 2000 - 12:25:59 CDT

Original text of this message

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