Search notes:

Oracle: DBMS_SESSION

Procedures and functions

clear_all_context Clears context information in a given namespace.
clear_context
clear_identifier
close_database_link Closes a database link, equivalent to alter session close database link ….
current_is_role_enabled Determines if a named role is currently enabled. Compare with is_role_enabled
free_unused_user_memory
get_package_memory_utilization
is_role_enabled Deprecated in favor of current_is_role_enabled and session_is_role_enabled.
is_session_alive
list_context Lists a session's active namespaces and contexts.
modify_package_state
reset_package Frees the memory being used for caching the execution state of all packages used in current session.
session_is_role_enabled Determines if a role is enabled in the current session.
session_trace_disable Resets the session-level SQL trace for the session from which it was called.
session_trace_enable Enables session level SQL statement execution tracing for the invoking session.
session
set_context Sets a value for an attribute in a context.
set_edition_deferred Requests to switch to an edition.
set_identifier
set_nls Equivalent to alter session set nls-parameter.
set_role Sets a role, equivalent to the set role … statement.
set_sql_trace Turns on or off SQL statement execution tracing(?) (SQL Trace facility?). Equivalent to alter session set sql_trace …. Compare with dbms_monitor.database_trace_enable.
sleep Suspends a session for the given amount of seconds, compare with (the deprecated) dbms_lock.sleep.
switch_current_consumer_group
unique_session_id

See also

session
Oracle DBMS PL/SQL packages

Index