Load test code/data needed

[Natik]

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.

[kris123]

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

[bazza]

What are you testing? Load on your machine for what?

[Natik]

Does anyone know of any tool to do load test that is free of charge and easy to use.