Seer Computing Limited - Site Map

Contents

This course deals with tuning the 9i Database to get the most efficient storage configuration as well as the best performance times.
The course includes the following aspects:

Avoiding locking and contention problems
Tune and troubleshoot SGA buffers
Tune and troubleshoot the shared pool
Tune and troubleshoot data file configuration problems
Use utlBstat and utlEsts and/or statspack




Exercises

There are practical and comprehensive exercises scheduled throughout the course to ensure delegates leave with a sound theoretical and practical knowledge.



Duration

Three Days

9i DBA I

This course presents techniques for finding and solving performance or configuration problems within the Oracle 9i database.
Manual techniques as well as those employing speciality packs within Oracle Enterprise Manager are considered

Pre-Requisite Course(s)
9i DBA I

Next Course(s)
9i Network Administration