Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

A couple that I know about are

Are there any others? I am looking for tools what can generate random workload (based on some parameters) that can be saved (possibly as an SQL file) and run against an Oracle 11gR2 db separately.

share|improve this question

3 Answers 3

Lazer,

Here are what I have found: Load and Performance Tools. This is a huge list of tools, you can find out what product is better for you, but I could not see any tool that has been created specially for Oracle databases (on my first sight). For Sql Server

An information resource for software testers

I hope it will help you.

ADDED:

The best generator that you made yourself.

share|improve this answer

Not free (tho' Oracle 11g isn't cheap either!) but the "official" solution is RAT.

share|improve this answer

I was going to post the same question for SQL Server having done a bit of digging around recently.

How about the Transaction Processing Council (TPC) workload generators?

  • TPC-E is the latest OLTP benchmark.
  • TPC-C is the previous version of the OLTP benchmark
  • TPC-H is for OLAP/DSS.

If you're inclined to dig into the code, you may be able to re-purpose TPCCBench which is SQL Server specific.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.