|
Book Information |
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.
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
|
|
|
|