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