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.