Oracle performance tuning PDF guide download here: Guide.pdf
Oracle performance tuning video tutorial:
UPDATE: An updated version of the above document is available here: http://blog.hardeep.name/computer/20130410/oracle-performance-tuning/ (now includes case studies to showing application of the performance tuning ideas suggested.
|However, if you are new to the topic, I recommend watching the video tutorial first to get some background.|
This includes additionally, process tuning and application tuning. It discusses the nuances of Oracle performance tuning, without getting into complex technicalities like cost based / role based optimizers.