-- dbms_application_info Package

select osuser,username, client_info, module, action 
from v$session
where osuser = 'dbstaruser'
/


-- PL/SQL Block to set dbms_application_info
biCounter:=biCounter+1;
vcDescription := 
 'Count: '||to_char(biCounter)||' '||
 floor((dEndDate-dStartDate)*24*60*60/3600)
 || ' HRS, ' ||
 floor((((dEndDate-dStartDate)*24*60*60) - floor(((dEndDate-dStartDate)*24*60*60)/3600)*3600)/60)
 || ' MINS, ' ||
 round((((dEndDate-dStartDate)*24*60*60) - floor(((dEndDate-dStartDate)*24*60*60)/3600)*3600 -
   (floor((((dEndDate-dStartDate)*24*60*60) - floor(((dEndDate-dStartDate)*24*60*60)/3600)*3600)/60)*60)))
 || ' SECS ' ;
dStartDate:=sysdate;

-- set client info column of v$session
dbms_application_info.set_client_info(vcDescription);

-- set module column of v$session
dbms_application_info.set_module('postproc1','');

-- set action column of v$session
dbms_application_info.set_action('');