Tuning Instance   «Prev  Next»
Lesson 1

Tuning the Oracle Instance

For this course make sure that you read the course-specific information about your exercises and the course project. This course takes an in-depth look into the memory internals of the Oracle SGA.
You will learn how to identify and diagnose Oracle memory performance problems, including problems in
  1. the library cache,
  2. data buffer cache, and
  3. data dictionary cache.

Once you complete this course, you will be able to handle any SGA-related slowdown, and will have a set of pre-written SQL scripts that you can use to quickly identify performance problems. The course enables you to have a firm understanding of Oracle SGA structures and be able to understand the internal memory mechanisms of the Oracle RDBMS database.

The Performance Tuning Series

The courses in the series allow you to delve in detail into the various concepts that comprise Oracle performance tuning.
  1. Performance Tuning Basics
  2. Tuning the Oracle Instance
  3. Tuning Oracle SQL
  4. Tuning the External Oracle Environment
  5. Oracle Tuning Concepts

Course goals

After completing this second course, you will have the skills necessary to:
  1. Tune the Oracle shared pool
  2. Tune the data buffer cache
  3. Tune Oracle rollback segments
  4. Tune Oracle redo mechanisms
  5. Monitor and detect lock contention
  6. Identify Oracle sort operations
If you have already taken the first course in this series, then you may already be somewhat familiar with this material. In either case, this PDF file provides you with a helpful resource for preparing to pass an OCP.
In keeping with its commitment to provide standards for technical competency, Oracle has given the exams associated with the Oracle Certified Professional Program a huge amount of internal Oracle support. The company provides in-depth technical specifications and sample exams to assist candidates in preparing for certification.
The next lesson outlines the prerequisites for this course.