Re: DBMS_SYSTEM

Niall Litchfield wrote:
>
> 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
> >

its definitely there - could be 'o7_diction...' parm

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."