PACKAGE DBMS_SYSTEM

PACKAGE DBMS_SYSTEM

The package DBMS_SYSTEM is installed by running the script

    $ORACLE_HOME/rdbms/admin/dbmsutil.sql

This script is called by

    $ORACLE_HOME/rdbms/admin/catproc.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_system TO PUBLIC;
    CREATE PUBLIC SYNONYM dbms_system FOR dbms_system;

In Oracle 9.2 procedures and functions include

 

PROCEDURE KSDDDT
PROCEDURE KSDFLS
PROCEDURE KSDIND
PROCEDURE KSDWRT
PROCEDURE SET_SQL_TRACE_IN_SESSION
PROCEDURE SET_BOOL_PARAM_IN_SESSION
PROCEDURE SET_INT_PARAM_IN_SESSION
PROCEDURE SET_EV
PROCEDURE READ_EV