Oracle 1Z0-033 Exam Details & Actual Exam Questions

Oracle9i Database:Performance Tuning Exam Questions

(45 Up Votes)

Certification Vendor:	Oracle
Exam Name:	Oracle9i Database: Performance Tuning
Exam Number:	1Z0-033
Certificate Validity Period:	No expiration (version-specific)
Real Exam Qty:	65
Exam Price:	$125 USD
Exam Format:	Multiple Choice
Passing Score:	70% (46 out of 65)
Exam Duration:	90 minutes
Available Languages:	English, Japanese
Related Certifications:	Oracle9i Certified Associate (OCA) Oracle9i Certified Master (OCM)
Recommended Training:	Oracle9i Database: Performance Tuning Course
Exam Registration:	Pearson VUE Oracle University
Sample Questions:	Oracle 1Z0-033 Sample Questions
Exam Way:	In-person at Pearson VUE or Prometric testing centers
Pre Condition:	Recommended: Oracle9i Database Administration Fundamentals I & II knowledge; Official training required for full OCP certification
Official Syllabus URL:	https://education.oracle.com/

Section	Weight	Objectives
Topic 1: I/O and Storage Tuning	15%	- Reducing I/O contention - Tablespace and datafile layout - Block structure and space usage
Topic 2: Diagnostic and Tuning Tools	12%	- Dynamic performance and data dictionary views - Alert log and trace files - Statspack installation and usage
Topic 3: SQL and Application Tuning	10%	- Efficient block usage - SQL statement optimization
Topic 4: Contention Management	15%	- Latch contention diagnosis - Lock and enqueue management - Rollback/undo segment tuning
Topic 5: OS and Resource Management	5%	- Operating system considerations - Oracle Resource Manager
Topic 6: Sort Operations Tuning	8%	- Sort area configuration - Identifying and resolving sort bottlenecks
Topic 7: Performance Tuning Methodology	10%	- System and database tuning phases - Tuning objectives and approach
Topic 8: Server Architecture Tuning	7%	- Shared vs dedicated server configuration
Topic 9: SGA and Memory Tuning	18%	- Shared pool configuration and tuning - Database buffer cache management - Other SGA components