Set session preferences and security levels.
Equivalent to ALTER
SESSION and SET ROLE statements.
Subprocedures:
SET_IDENTIFIER Set the indentifier.
SET_CONTEXT Set the context.
CLEAR_CONTEXT Clear the context.
CLEAR_IDENTIFIER Clear the identifier.
SET_ROLE Set role.
SET_SQL_TRACE Turn tracing on or off.
SET_NLS Set national language support (NLS).
CLOSE_DATABASE_LINK Close database link.
RESET_PACKAGE 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
Determine if the specified session is alive.
SET_CLOSE_CACHED_OPEN_CURSORS
Turn close_cached_open_cursors on or off.
FREE_UNUSED_USER_MEMORY
Reclaim unused memory - use after performing an operation
that required a large amount of memory.
SET_CONTEXT Set or resets the value of a context attribute.
LIST_CONTEXT Returns a list of active namespace and context for the current session.
SWITCH_CURRENT_CONSUMER_GROUP
Change the current resource consumer group of
a user's current session.
For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"
or the book Oracle Built in Packages
by Steven Feuerstein et al
Related:
V$SESSION