DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Load test code/data needed

  1. #1
    Join Date
    Nov 2001
    Posts
    110

    Load test code/data needed

    Does anyone have a test schema that can be used to generate load on the database. With objects like packages, indexes, insert,updates, deletes, selects going on in the schema to test the performance of the database. I think that some packages with a loop can be utilized to do an insert, update, delete operation. Hopefully someone can help share some code for testing/load testing.

  2. #2
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Hi pogi,

    Maybe you can use this to populate test data, but u have to edit some
    values to satisfy your test criteria.

    sql> begin
    for i in 1..1000 loop
    insert into test values ('value1','value2',.....);
    end loop;
    commit;
    end;
    /

  3. #3
    Join Date
    Jul 2002
    Posts
    335
    What are you testing? Load on your machine for what?

  4. #4
    Join Date
    Nov 2001
    Posts
    110
    Does anyone know of any tool to do load test that is free of charge and easy to use.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width