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:
Describe the main components of the Oracle SGA
Describe the operation of the shared pool
Describe the functions of the library cache
Query the data dictionary cache
List the UGA and session memory considerations
Describe how the data buffer cache affects performance
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.
- Application statistics (transaction volumes, response time)
- Database statistics
- Operating system statistics
- Disk I/O statistics
- Network statistics
In the Automatic Workload Repository, baselines are identified by a range of snapshots that are preserved for future comparisons.