Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Packages

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