Oracle in a Nutshell

Calls

PROCEDURE DBMS_SESSION.CLEAR_IDENTIFIER;

Removes the value of the session’s client ID. New with Oracle9i.

PROCEDURE DBMS_SESSION.CLOSE_DATABASE_LINK (dblink IN VARCHAR2);

Closes the database link dblink or raises an exception if dblink is not open or is in use.

PROCEDURE DBMS_SESSION.FREE_UNUSED_USER_MEMORY;

Releases freeable session memory back to the operating system (for a dedicated connection) or the Oracle shared pool (for a Shared Server connection).

FUNCTION DBMS_SESSION.IS_ROLE_ENABLED (rolename IN VARCHAR2) RETURN BOOLEAN;

Returns TRUE if the rolename is currently enabled in the session.

FUNCTION DBMS_SESSION.IS_SESSION_ALIVE (uniqueid IN VARCHAR2) RETURN BOOLEAN;

Returns TRUE if the session identified by uniqueid is still alive. New with Oracle8i.

PROCEDURE DBMS_SESSION.LIST_CONTEXT (list OUR AppCtxTabTyp, size OUT NUMBER);

Returns information about the current context in a table of AppCtxTabType. size is the number of entries returned in the buffer. New with Oracle8i.

PROCEDURE DBMS_SESSION.MODIFY_PACKAGE_STATE (action_flags IN PLS_INTEGER);

Modifies the package state either with FREE_ALL_RESOURCES, which frees all memory associated with the previously run PL/SQL programs, clears the value of package globals, and closes cached cursors, or with REINITIALIZE, which reinitializes packages and reuses package memory. New with Oracle9i.

PROCEDURE DBMS_SESSION.LIST_CONTEXT (list OUT AppCtxTabTyp, size OUT NUMBER);

Returns a list of namespaces, attributes, and values ...