Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_APPLICATION_INFO, 4 of 7
This procedure reads the values of the module and action fields of the current session.
DBMS_APPLICATION_INFO.READ_MODULE ( module_name OUT VARCHAR2, action_name OUT VARCHAR2);
Parameter | Description |
---|---|
module_name |
Last value that the module name was set to by calling |
action_name |
Last value that the action name was set to by calling |
Module and action names for a registered application can be retrieved by querying V$SQLAREA
or by calling the READ_MODULE
procedure. Client information can be retrieved by querying the V$SESSION
view, or by calling the READ_CLIENT_INFO
procedure.
Example
The following sample query illustrates the use of the MODULE
and ACTION
column of the V$SQLAREA
.
SELECT sql_text, disk_reads, module, action FROM v$sqlarea WHERE module = 'add_employee'; SQL_TEXT DISK_READS MODULE ACTION ------------------- ---------- ------------------ ---------------- INSERT INTO emp 1 add_employee insert into emp (ename, empno, sal, mgr, job, hiredate, comm, deptno) VALUES (name, next.emp_seq, manager, title, SYSDATE, commission, department) 1 row selected.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|