PL/SQL Packages DBMS_APPLICATION_INFO

Record the name of an executing module (or transaction) in the database for later use with Oracle Trace and the SQL trace facility.

Subprocedures:

SET_MODULE          Set the name of the module that is currently
                    running to a new module. 

SET_ACTION          Set the name of the current action
                    within the current module. 

READ_MODULE         Read the values of the module and
                    action fields of the current session. 

SET_CLIENT_INFO     Set the client info field of the session. 

READ_CLIENT_INFO    Read the value of the client_info field of
                    the current session. 

SET_SESSION_LONGOPS Set a row in the V$SESSION_LONGOP table. 

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al

Related Commands:

    Application info can be pushed into V$SESSION/V$SESSION_LONGOPS

Related Views: