Pass application info through to the Oracle RDBMS

The following code tells the database what the application is up to: 

begin

   dbms_application_info.set_client_info('BANCS application info');

   dbms_application_info.set_module('BANCS XYZ module', 'BANCS action name');

end;

/

-- Retrieve application info from the database:

select module, action, client_info

from   sys.v_$session where audsid = USERENV('SESSIONID')

/

select sql_text

from   sys.v_$sqlarea

where  module = 'BANCS XYZ module'

and  action = 'BANCS action name'