This module will provide an overview of Oracle instance tuning and will introduce you to the overall instance components that we will be investigating in detail throughout the course. It will also provide you with some background about the types of performance problems that you will learn to diagnose and resolve as you make your way through the rest of Oracle Instance Tuning.
By the time you complete this module, you should be able to:

1. Describe the main components of the Oracle SGA
2. Describe the operation of the shared pool
3. Describe the functions of the library cache
4. Query the data dictionary cache
5. List the UGA and session memory considerations
6. Describe how the data buffer cache affects performance
7. Describe the performance issues related to the redo log buffer

In the next lesson, we will begin by reviewing the main components of an Oracle instance.