Stress Testing using Grid Control

Created a number of scheduled SQL jobs to push through many transactions and see what happens :-)

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;

Top Clients

Top Modules (by Service)

Top Actions (by Module) (by Service)

Create Index (Alan Stress Test 2) (SYS$USERS)(20.1%)

Create Index (Alan Stress Test 1) (SYS$USERS)(15.9%)

Unnamed (Unnamed) (SYS$BACKGROUND)(15.6%)

Create Index (Alan Stress Test 4) (SYS$USERS)(9.1%)

Create Index (Alan Stress Test 3) (SYS$USERS)(9.1%)

Create Table (Alan Stress Test 3) (SYS$USERS)(3.5%)

Create Table (Alan Stress Test 4) (SYS$USERS)(3.4%)

Create Table (Alan Stress Test 1) (SYS$USERS)(2.5%)

Create Table (Alan Stress Test 2) (SYS$USERS)(2.5%)

Delete from Table (Alan Stress Test 3) (SYS$USERS)(1.8%)

Other(16.5%)