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

closed as off-topic by Paul White, tblPhil, dezso, Aaron Bertrand Jan 26 at 14:48

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, tblPhil, dezso, Aaron Bertrand
If this question can be reworded to fit the rules in the help center, please edit the 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

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