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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to dedicate some time to learn more about performance and tuning issues. I assign for that a clean DB. I want to know how can I load into it some data and performance-problem queries/DML/DDL? Do you know some scripts that can cause/generate that (purposely or not)?

The idea is to learn the basic(and maybe more) of em/awr/addm etc - tuning and performance wise. I dont really know what specific to ask, but I'm guessing index problems, selects issues, wrong way to access the data, etc..

Books are great but I have the knowledge I need some actual work on that.

Maybe its not a Q&A at all, but for me any answer (as long as it is an answer to my question) will do.

EDIT I dont want just a server load script - because thats has no point, plus thats not what I want.

share|improve this question

closed as too broad by billinkc, Phil, Aaron Bertrand Aug 30 '13 at 21:58

There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded to fit the rules in the help center, please edit the question.

Please re-phrase in a way that would make it possible to have one self-contained answer for this question. I think you should begin with "Are there any reliable statistics about the most common causes of performance problems among Oracle database users?" – kubanczyk Aug 31 '13 at 12:05
I dont really care or know good problems. I want it to be complicated that will get me thinking.. – nirrbared Sep 2 '13 at 18:39

This is a pretty broad topic that would largely depend on your specific needs.

Here is a link to a fairly recent article about load testing tools. It provides pros and cons of several different options:

Personally, I like the Silly Little Oracle Benchmark (SLOB).

share|improve this answer

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