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; |
|