(1Z0-033) Performance Tuning

SYNOPSIS • Oracle9i DBA OCP ^vs

Oracle’s Oracle 9i exam 1Z0-033, “Oracle9i: Performance Tuning” is a core requirement for the Oracle 9i OCP (Oracle Certified Professional) certification. It is designed for mid to advanced level database personnel. There is no specific prerequisite for this exam.

This exam costs $125 USD and may be taken from Thomson Prometric.

The pass score for this form-based multiple choice exam is 64%. There are 59 scored questions (“your exam may contain unscored questions in addition to the scored questions”) and the exam lasts 1.5 hours.

The topics covered by this exam include:

• Overview of Oracle9i Performance Tuning
• Diagnostic and Tuning Tools
• Sizing the Shared Pool
• Sizing the Buffer Cache
• Sizing other SGA Structures
• Database Configuration and I/O Issues
• Optimize Sort Operations
• Diagnosing Contention For Latches
• Monitoring and Detecting Lock Contention
• Tuning Oracle Shared Server
• Application Tuning
• Using Oracle Blocks Efficiently
• SQL Statement Tuning
• Tuning the Operating System and Using Resource Manager

For more information:
http://www.oracle.com/education/certification/objectives/index.html?33.html