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_APPLICATION_INFO.READ_CLIENT_INFO (client_info OUT VARCHAR2);

Returns the currently registered client_info for the session.

PROCEDURE DBMS_APPLICATION_INFO.READ_MODULE (module_name OUT VARCHAR2, action_name OUT VARCHAR2);

Returns the currently registered module_name and action_name for the session.

PROCEDURE DBMS_APPLICATION_INFO.SET_ACTION (action_name IN VARCHAR2);

Registers action_name into V$SESSION and V$SQLAREA as the current action for the session.

PROCEDURE DBMS_APPLICATION_INFO.SET_CLIENT_INFO (client_info IN VARCHAR2);

Registers client_info into V$SESSION as the current client information for the session.

PROCEDURE DBMS_APPLICATION_INFO.SET_MODULE (module_name IN VARCHAR2, action_name IN VARCHAR2);

Registers module_name and action_name into V$SESSION and V$SQLAREA as the current module and action for the session.

PROCEDURE DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS (rindex IN OUT BINARY_INTEGER, slno IN OUT BINARY_INTEGER, op_name IN VARCHAR2 DEFAULT NULL, target IN BINARY_INTEGER DEFAULT 0, context IN BINARY_INTEGER DEFAULT 0, sofar IN NUMBER DEFAULT 0, totalwork IN NUMBER DEFAULT 0, target_desc IN VARCHAR2 DEFAULT 'unknown target', units IN VARCHAR2 DEFAULT NULL);

Inserts or updates runtime data for long-running operations in the V$SESSION_LONGOPS virtual table. Rows are identified by the value of rindex. A new row is acquired when rindex is set to the package constant SET_SESSION_LONGOPS_NOHINT. Unique combinations of other parameters may also ...

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