PACKAGE DBMS_SESSION

PACKAGE DBMS_SESSION

The package DBMS_SESSION 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 all users with CONNECT privileges can execute the procedures and functions in this package.

Procedures and functions include

 

PROCEDURE SET_SQL_TRACE