Oracle Technology‎ > ‎Enterprise Manager‎ > ‎em notes‎ > ‎

Stress Testing using Grid Control

posted 20 Jul 2009, 08:17 by Alan Nolan-Davies   [ updated 22 Jul 2011, 08:04 ]
Using Grid Control Jobs to generate Load on the Database   


exec dbms_session.set_identifier('Alan Stress Test 5');
exec dbms_application_info.set_module('Alan Stress Test 5','Create Table');
create table alanstresstest5 as select * from alanloadtest;
exec dbms_application_info.set_module('Alan Stress Test 5','Query Table');
select count(*) from alanstresstest5;
exec dbms_application_info.set_module('Alan Stress Test 5','Update Table');
update alanstresstest5 set status =  'STRESS' where owner='ALANNOLANDAVIES';
exec dbms_application_info.set_module('Alan Stress Test 5','Create Index');
create index stressindex5 on alanstresstest5(object_name);
exec dbms_application_info.set_module('Alan Stress Test 5','Delete from Table');
delete from alanstresstest5 where object_id between 1000 and 2000;
exec dbms_application_info.set_module('Alan Stress Test 5','Query Table');
select count(*) from alanstresstest5;
exec dbms_application_info.set_module('Alan Stress Test 5','Drop Table');
drop table alanstresstest5;

Ċ
Alan Nolan-Davies,
20 Jul 2009, 09:03
Comments