In order to get the most out of this course, you should have a solid grasp of the basics of Oracle tuning concepts.
However, you should also have a basic understanding of the
- UNIX operating system,
- PL/SQL coding techniques
, and the following Oracle database concepts:
Prior to taking this course, you should be able to do the following:
Identify and diagnose Oracle memory performance problems, including problems in the library cache, data buffer cache, and
data dictionary cache
Understand basic Oracle tuning techniques, metrics and tuning goals for measuring and monitoring performance
Understand basic Oracle SGA and memory management concepts
If you have not yet mastered these skills, consider visiting on of the other links posted above.
In the next lesson, you will learn about the hardware and software you will need to take this course.