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
Application info can be pushed into V$SESSION/V$SESSION_LONGOPS