Home » RDBMS Server » Performance Tuning » DBMS_APPLICATION_INFO Usage
DBMS_APPLICATION_INFO Usage [message #262078] Fri, 24 August 2007 07:59 Go to next message
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;


Re: DBMS_APPLICATION_INFO Usage [message #262086 is a reply to message #262078] Fri, 24 August 2007 08:07 Go to previous message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
The code looks OK. While its running you can look at the Module and Action values in V$SESSION using another window .

Ross Leishman
Previous Topic: about add more cpus..
Next Topic: Output of Query is very slow through SQL
Goto Forum:
  


Current Time: Fri Jun 28 10:40:09 CDT 2024