Basic methods of Oracle performance optimization
1. Set reasonable performance optimization goals
2. Test and record the current performance
3. Determine the current Oracle performance bottleneck
4. Wait a wait event into the trace file
5. Determine the current OS bottleneck
6. Optimize the necessary components
7. Track and implement the change control process
8. Test and record current performance
Repeat 3-7 until the optimization goal
