Oracle Applications

Basic Performance Tuning

By Hervé Deschamps.

This is a one page list of simple guidelines to tune SQL without much DBA knowledge.

This is all you need to know to tune some reports from 2 hours (or more) to 20 seconds (or less). I have compiled this list during a report tuning assignment
where I achieved that kind of runtime improvements repeatedly.

There are many more tips but they tend to be more difficult to understand and there are many good books already written about this.

Beyond the Simple stuff ...

If you remember nothing else ...


Please send me comments or suggestions:
 Take a look at my HomePage