rem -----------------------------------------------------------------------
rem Filename:   appinfo.sql
rem Purpose:    Example of how to pass application info through to Oracle RDBMS
rem Author:     Frank Naude, Oracle FAQ
rem -----------------------------------------------------------------------

-- 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'
/