SCRIPTS :

Run the following script :


Example of how to pass application info through to 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'
/