Oracle Database 10g: Performance Tuning
Duration: 4 Days
The purpose of this course is to equip database administrators to recognize, diagnose and remedy performance problems which might arise in the operation of the Oracle database server. Beyond reactive measures, proactive actions which can be taken to avoid performance issues before they arise or are recognized are also considered.
Topics Covered In This Course
PERFORMANCE TUNING OVERVIEW
STATISTICS AND WAIT EVENTS
AUTOMATIC TUNING AND AWR
METRICS, ALERTS AND BASELINES
TUNING MEMORY: THE SHARED POOL
TUNING MEMORY: THE BUFFER CACHE
TUNING MEMORY: AUTOMATIC SHARED MEMORY
TUNING I/O: CHECKPOINT AND REDO TUNING
TUNING I/O: DATABASE WRITES
SPACE TUNING: PGA AND TEMPORARY SPACE
SPACE TUNING: BLOCK SPACE USAGE
© Copyright 2008 – Sideris Courseware
What You Can Expect
This course goes beyond basic automatic tuning techniques discussed elsewhere within our database administrator curriculum and covers the whole range of tuning issues, including manual database tuning techniques, host system tuning, network and listener tuning, and others. Among the specific subjects discussed in this course are:
Who Should Take This Course
The target audience for this course is Oracle database administrators and data center support engineers and consultants. Additionally, senior database developers will benefit from an understanding of the architecture of the Oracle database with which they interface.
Instructor led lectures, combined with hands-on labs.
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.
Can't find the course you want?
Call us at 800.533.3893, or
email us at email@example.com