1Z0-064: Oracle Database 12c - Performance Management and Tuning


Exam Number: 1Z0-064

Exam Title: Oracle Database 12c - Performance Management and Tuning


Associated Certification Paths



Oracle 1Z0-064 Certification Details:


Exam Name Oracle Database 12c: Performance Management and Tuning
Exam Code 1Z0-064
Exam Product Version Oracle Database 12c
Exam Price USD $245
Duration 150 minutes
Number of Questions 84
Passing Score 61%
Validated Against Exam has been validated for product version 12.1.0.1.0
Format Multiple Choice
Recommended Practice 1Z0-064 Online Practice Exam
Recommended Training Oracle Database 12c: Performance Management and Tuning

Oracle 1Z0-064 Certification Topics:



Basic Tuning Diagnostics
  • Describe the time model
  • Explain wait events
  • Diagnose performance problems using V$ views
Using Automatic Workload Repository
  • Analyze database performance using AWR reports
Using Metrics and  Alerts
  • Monitor performance using metric thresholds and alerts
Using Baselines
  • Use AWR baselines to monitor performance
Using AWR-Based Tools
  • Diagnose performance issues using ADDM
  • Diagnose performance issues using  ASH reports
Monitoring Real-Time Database Operation
  • Implement Real-Time Database Operation Monitoring
Monitoring Applications
  • Configure and use services to monitor database performance
Identifying Problem SQL Statements
  • Interpret execution plans
  • Use formatted output of SQL Trace or the optimizer trace to identify poorly performing SQL statements
Influencing the Optimizer
  • Explain how statistics influence the optimizer
  • Configure parameters to influence the optimizer
Reducing the Cost of SQL Operations
  • Use Automatic Segment Space Management to optimize space management
  • Use table compression
  • Diagnose and tune space related issues
Using SQL Performance Analyzer
  • Use SQL Performance Analyzer to test the impact of database changes
SQL Performance Management
  • Manage optimizer statistics
  • Use SQL Profiles and Advisors to tune SQL statements
  • Use SQL Plan Management to tune SQL statements
Using Database Replay
  • Use Database Replay to check impact of system change on performance
Tuning the Shared Pool
  • Diagnose and resolve hard and soft parsing problems
  • Diagnose and resolve performance issues related to the shared pool
Tuning the Buffer Cache
  • Diagnose and resolve performance issues related to the buffer cache
Tuning PGA and Temporary Space
  • Diagnose and resolve performance issues related to PGA
  • Diagnose and resolve performance issues related to temporary tablespace
Using Automatic Memory
  • Use and tune  Automatic Shared Memory Management
  • Use and tune Automatic Memory Management
Tuning I/O
  • Diagnose database I/O issues
  • Configure Automatic Storage Management (ASM) for maximum availability
Using the Database Resource Manager
  • Understand and configure the Database Resource Manager

Oracle 1Z0-064 - Oracle Database 12c - Performance Management and Tuning Exam Preparation: