Oracle8i Performance Tuning: Tuning the Shared Pool and Buffer Cache

Oracle8i Performance Tuning: Tuning the Shared Pool and Buffer Cache

Overview/Description
Explain how to tune and configure the key areas of memory and avoid memory contention

Target Audience
Network administrators, database administrators

Prerequisites
Completion of the Oracle Introduction, Oracle8i Database Administration, and Oracle8i Backup and Recovery SmartCurricula

Expected Duration
4:00 Hours

Objectives:

Oracle8i Performance Tuning: Tuning the Shared Pool and Buffer Cache

To explain how to approach and implement library cache tuning

To explain how to tune the data dictionary cache and the User Global Area (UGA), and how to configure the large pool

To explain how to manage the database buffer cache

To outline strategies for avoiding contention in the database buffer cache

Course Number: OR852SE