|
--------------------------------------------------------------------------------
-- PROCEDURE LOAD_TEST_ADD_DATA
--
-- Purpose used to generate a very heavy, non-optimized write load
-- Limitations None
-- Version 1.0
-- Oracle Version 10.2
-- Date 19 Oct 2007
--
-- Disclaimer This source code is provided free by Texas Memory Systems. This
-- software is provide without support, and the user assumes all
-- risk in it's use. You may use, or modify this in any way that
-- you choose
--------------------------------------------------------------------------------
-- it requires two simple tables
-- the create scripts is below
--
drop table load_test_simple
/
drop table loop_timer
/
create table load_test_simple(test number)
/
create table loop_timer ( tstamp timestamp)
/
create or replace procedure load_test_add_data
as
begin
--
-- 1,000,000 inserts
--
for idx in 1 ..1000000 loop
insert into load_test_simple values (idx);
commit;
end loop;
insert into loop_timer values (systimestamp);
end;
/
create or replace procedure make_load_no_del
as
begin
for idx in 1 ..100000 loop
load_test_add_data;
commit;
end loop;
end;
/
|