| After completing this course, you should | ||
| be able to do the following: | ||
| List the important steps for outlining a tuning methodology | ||
| Use Oracle tools to diagnose performance problems | ||
| Configure memory resources to optimize cache operations | ||
| Reconfigure file structures to enhance performance | ||
| Identify and resolve I/O, storage, and database configuration problems | ||
| Detect and resolve latch and lock contention problems | ||
| Configure memory and disk resources to optimize sort operations | ||
| Diagnose and resolve performance issues associated with the multithreaded server | ||
| List options to enhance performance across differing application environments | ||