Contact Us  |  Ask for Pricing  |  Partners

The World's Fastest Storage®
 

superSSD > Education > Oracle Performance Center > Code List

Oracle Performance Center - Code List

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

Texas Memory Systems Sales - Call (713) 266-3200

Sign up for the RamSan Mailing List

Home  |  Company  |  Products  |  Support  |  Resources  |  Partners
 Contact Us  |  Legal  |   Library  |  Press  |  Success Stories  |  Privacy Policy

Copyright © 2006 Texas Memory Systems. All Rights Reserved.