DBMS APPLICATION INFO

From Oracle FAQ
Jump to: navigation, search

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[edit]

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');