58
DBMS_SESSION

This package provides access to SQL ALTER SESSION and SET ROLE statements, and other session information, from PL/SQL. You can use this to set preferences and security levels.

This chapter discusses the following topics:

• Requirements

• Summary of DBMS_SESSION Subprograms

Requirements

This package runs with the privileges of the calling user, rather than the package owner SYS.

Summary of DBMS_SESSION Subprograms

Table 58-1 DBMS_SESSION Subprograms

Subprogram	Description
"SET_IDENTIFIER"	Sets the indentifier.
"SET_CONTEXT" and	Sets the context.
"CLEAR_CONTEXT"	Clears the context.
"CLEAR_IDENTIFIER"	Clears the identifier.
"SET_ROLE Procedure"	Sets role.
"SET_SQL_TRACE Procedure"	Turns tracing on or off.
"SET_NLS Procedure"	Sets national language support (NLS).
"CLOSE_DATABASE_LINK Procedure"	Closes database link.
"RESET_PACKAGE Procedure"	Deinstantiates all packages in the session.
"UNIQUE_SESSION_ID Function"	Returns an identifier that is unique for all sessions currently connected to this database.
"IS_ROLE_ENABLED Function"	Determines if the named role is enabled for the session.
"IS_SESSION_ALIVE Function"	Determines if the specified session is alive.
"SET_CLOSE_CACHED_OPEN_CURSORS Procedure"	Turns close_cached_open_cursors on or off.
"FREE_UNUSED_USER_MEMORY Procedure"	Lets you reclaim unused memory after performing operations requiring large amounts of memory.
"SET_CONTEXT Procedure"	Sets or resets the value of a context attribute.
"LIST_CONTEXT Procedure"	Returns a list of active namespace and context for the current session.
"SWITCH_CURRENT_CONSUMER_GROUP Procedure"	Facilitates changing the current resource consumer group of a user's current session.