Notes

Outline

Course Introduction

Course Objectives 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

Course Objectives 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