December 2002
Intermediate to advanced
928 pages
85h 29m
English
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 ...