Exam 1Z0-033: Oracle9i Performance Tuning
 |  E X A M   D I F F I C U L T Y
   


| |
|
|
SYNOPSIS Oracle9i DBA OCP
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
Helpful: Compare this exam with others.
|