Re: DBMS_SYSTEM

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 12 Dec 2002 13:47:46 -0000
Message-ID: <3df89382$0$712$ed9e5944@reading.news.pipex.net>

I was missing the obvious. The account I was using wasn't as privileged as I thought it was. DBMS_SUPPORT you have to manually install (though the script itself suggests that you wait for support to tell you to do this)

SQL> desc sys.dbms_support;
FUNCTION MYSID RETURNS NUMBER
FUNCTION PACKAGE_VERSION RETURNS VARCHAR2 PROCEDURE START_TRACE

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 WAITS                          BOOLEAN                 IN     DEFAULT
 BINDS                          BOOLEAN                 IN     DEFAULT
PROCEDURE START_TRACE_IN_SESSION
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SID                            NUMBER                  IN
 SERIAL                         NUMBER                  IN
 WAITS                          BOOLEAN                 IN     DEFAULT
 BINDS                          BOOLEAN                 IN     DEFAULT

PROCEDURE STOP_TRACE
PROCEDURE STOP_TRACE_IN_SESSION

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SID                            NUMBER                  IN
 SERIAL                         NUMBER                  IN

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Matthias Rogel" <rogel_at_web.de> wrote in message
news:ata34i$11rgtf$1_at_ID-86071.news.dfncis.de...


> Niall Litchfield wrote:

> > This seems to have disappeared in 9.2. I see that the ability to start

> > tracing another users session has moved to (and been improved in)

> > dbms_support. Has the package actually disappeared or am I missing the

> > obvious again.

> >

> > --

> > Niall Litchfield

> > Oracle DBA

> > Audit Commission UK

> > *****************************************

> > Please include version and platform

> > and SQL where applicable

> > It makes life easier and increases the

> > likelihood of a good answer

> >

> > ******************************************

> >

> >

>
>


> SQL> select * from v$version;

>


> BANNER

> ----------------------------------------------------------------

> Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production

> PL/SQL Release 9.2.0.1.0 - Production

> CORE    9.2.0.1.0       Production

> TNS for 32-bit Windows: Version 9.2.0.1.0 - Production

> NLSRTL Version 9.2.0.1.0 - Production

>


> SQL> select object_type,object_name

>    2  from all_objects

>    3  where

>    4  object_name in ('DBMS_SYSTEM','DBMS_SUPPORT');

>


> OBJECT_TYPE        OBJECT_NAME

> ------------------ ------------------------------

> PACKAGE            DBMS_SYSTEM

> PACKAGE BODY       DBMS_SYSTEM

>


> confused,

> Matthias

>

Received on Thu Dec 12 2002 - 07:47:46 CST