Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page