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
- the library cache,
- data buffer cache, and
- 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.
If you want to read more about the Oracle Certified Professional (OCP) program and learn the best strategies for passing the OCP exams,
you can download ocpexam.pdf from the Resources page. 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.