|
Oracle 9i Certified Professional DBA Performance Tuning Exam Guide
Prepare to pass the Oracle9i OCP DBA Performance Tuning exam using this focused, and complete guide. Covering all official exam objectives and containing over 300 practice questions, chapter self-tests, two minute drills, a glossary of key Oracle terms--plus a CD-ROM with a testing engine that simulates the actual exam--this is the best study tool
available.
CONTENTS:
PART I: OCP Tuning Exam Guide
1: Database Tuning Overview
2: Oracle Performance Tuning Methodology
3: Diagnostic and Tuning Tools
4: Sizing the Shared Pool
5: Sizing the Buffer Cache
6: Sizing Other SGA Structures
7: Database Configuration and I/O Issues
8: Optimize Sort Operations
9: Diagnosing Contention for Latches
10: Tuning Rollback or Undo Segments
11: Monitoring and Detecting Lock Contention
12: Tuning Oracle Shared Server
13: Application Tuning
14: Using Oracle Blocks Efficiently
15: SQL Statement Tuning
16: OS Considerations and Oracle Resource Manager
PART II: Practice Exams
17: Practice Exam 1 and 2
|
