DBMS_SESSION Package

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