Re: DBMS_SYSTEM

From: Matthias Rogel <rogel_at_web.de>
Date: Thu, 12 Dec 2002 14:32:02 +0100
Message-ID: <ata34i$11rgtf$1@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:32:02 CST