DBMS_APPLICATION_INFO Usage [message #262078] |
Fri, 24 August 2007 07:59 |
orasaket
Messages: 70 Registered: November 2006
|
Member |
|
|
Hi,
I want to Track progress of our Batch process job using DBMS_APPLICATION_INFO
The batch process is an Oracle job which invokes many other processes in sequence.
Before using this i tested 'how to use DBMS_APPLICATION_INFO' as follows
However, i am not able to understand, instead of set_module and set_action of this package if i insert values in any other table, what difference it will make.
I am sure i am not properly exploiting features of this package.At the same time i am unable to understand exacly what piece of information or feature i am not using to dept.
Please help.
Thanks and Regards,
OraSaket.
I tested as follows..
begin
dbms_application_info.set_client_info( SYS_CONTEXT('USERENV', 'OS_USER') );
DBMS_APPLICATION_INFO.set_module(module_name => 'start_upd_o1',
action_name => 'upd o1');
upd_o1;
DBMS_APPLICATION_INFO.set_action(action_name => 'update o1 one');
update o1 set owner=owner||'A';
commit;
DBMS_APPLICATION_INFO.set_action(action_name => 'update o1 two');
update o1 set object_type=replace(object_type,'a','b');
commit;
DBMS_APPLICATION_INFO.SET_MODULE( NULL,NULL );
end;
/
DBMS_APPLICATION_INFO.set_action(action_name => 'update o1 two');
update o1 set created=created+1-1;
commit;
DBMS_APPLICATION_INFO.SET_MODULE( NULL,NULL );
end;
|
|
|
|