PACKAGE DBMS_SUPPORT

PACKAGE DBMS_SUPPORT

The DBMS_SUPPORT package is available in Oracle 7.2 and above. It is not installed by default.

The package is supplied with Oracle 9.0.1 and 9.2.0. It was omitted from Oracle 8.1.7. If it is missing, it can be obtained from Oracle support. The following files are required

    dbmssupp.sql
    prvtsupp.plb

The package is installed by running the script

    $ORACLE_HOME/rdbms/admin/dbmssupp.sql

By default only the SYS user can execute procedures and functions in this package. To allow other users to execute this package, run the following commands as SYS

    GRANT EXECUTE ON dbms_support TO PUBLIC;
    CREATE PUBLIC SYNONYM dbms_support FOR dbms_support;

See Metalink Note 62294.1 for further information

In Oracle 9.2 procedures and functions include

 

FUNCTION MYSID
PROCEDURE START_TRACE
PROCEDURE STOP_TRACE
PROCEDURE START_TRACE_IN_SESSION
PROCEDURE STOP_TRACE_IN_SESSION