Oracle
Database Resource Manager (DBRM) to manage and prioritize resources
PGA and SGA sizing
Table of contents
AIX Oracle tuning
Table of contents
LogMiner setup and investigation with Oracle 10g and above
Script to generate series of awr reports
If you want to generate series of AWR reports, it is really boring to use the provided script awrrpt.sql as you have to launch it per each step of the interval. Following script automate this generation and will ask for the start and last snapshot and then generate all intermediate AWR reports.