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 |