Oracle 1z0-064 Exam Details & Actual Exam Questions

  • Exam Code/Number: 1z0-064
  • Exam Name/Title: Oracle Database 12c: Performance Management and Tuning
  • Certification Provider: Oracle
  • Corresponding Certification: Oracle Database
  • Exam Questions: 120
  • Updated On: Sep,23 2026
  • Certification Level: Professional

Oracle Database 12c: Performance Management and Tuning Exam Questions

View 1z0-064 actual exam questions, answers and explanations for free.

users 95% student found the test questions almost same

All the information you need to pass Oracle Database 12c: Performance Management and Tuning 1z0-064 exam and free practice exam verified by EduDump exam experts.

Said the test questions were almost same
Passed the exams with the material
Found the study quides effective and helpful
(26 Up Votes)

Oracle 1z0-064 Exam Overview:

Certification Vendor:Oracle
Exam Name:Oracle Database 12c: Performance Management and Tuning
Exam Number:1Z0-064
Related Certifications:Oracle Database 12c Administrator Certified Professional
Exam Duration:120 minutes
Exam Format:Multiple choice, Multiple response
Available Languages:English
Real Exam Qty:Approximately 60-80
Passing Score:Approximately 60%
Exam Price:$245 USD (may vary by region)
Certificate Validity Period:Oracle certification validity varies; many Database 12c certifications are historically non-expiring, but policies may differ by track
Recommended Training:Oracle Database Performance Tuning Courses
Oracle University - Database 12c Training
Exam Registration:Oracle Certification Registration
Pearson VUE Oracle Exams
Sample Questions:Oracle 1z0-064 Sample Questions
Exam Way:Computer-based exam delivered via Pearson VUE test centers or online proctored delivery (availability depends on region)
Pre Condition:Recommended: Oracle Database 12c Administrator Certified Professional (commonly including 1Z0-062 and 1Z0-063) or equivalent Oracle DBA experience
Official Syllabus URL:https://education.oracle.com/oracle-certification-exams

Oracle 1z0-064 Exam Syllabus Topics:

SectionObjectives
Topic 1: Optimizer and Execution Plans- Statistics and histogram usage
- Cost-based optimizer (CBO)
Topic 2: SQL Tuning- SQL execution performance analysis
  • 1. SQL trace and profiling tools
    • 2. Execution plans interpretation
      - SQL optimization techniques
      Topic 3: Concurrency and Locking- Locking mechanisms and contention
      - Transaction isolation and wait events
      Topic 4: I/O and Storage Performance- Disk I/O optimization strategies
      - ASM performance considerations
      Topic 5: Oracle Database Architecture and Performance Fundamentals- Database memory structures (SGA, PGA)
      - Background processes and workload flow
      Topic 6: Performance Diagnostics and Monitoring- Automatic Workload Repository (AWR)
      - ADDM analysis and recommendations
      Topic 7: Instance Tuning- Memory management and configuration
      • 1. Automatic Memory Management (AMM)
        • 2. Automatic Shared Memory Management (ASMM)
          - CPU and resource utilization tuning
          Topic 8: Space Management and Segment Performance- Tablespace and segment tuning
          - Extent and block management


          0
          0
          0
          10