DBMS APPLICATION INFO
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
DBMS_APPLICATION_INFO is a PL/SQL package used to expose application details to Oracle. For example, it allows you to set the module, action and provide additional application_info.
Examples
exec dbms_application_info.set_client_info('My program'); SELECT client_info FROM v$session WHERE audsid = USERENV('SESSIONID');
exec dbms_application_info.set_module('prog1'); exec dbms_application_info.set_action('busy reading data'); SELECT module, action FROM v$session WHERE audsid = USERENV('SESSIONID');