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

Full Name: Oracle Database 12c - Performance Management and Tuning

Exam Code: 1Z0-064

Try Sample Exam »

Oracle 1Z0-064 Exam Details:

Exam Name	Oracle Database 12c - Performance Management and Tuning
Exam Code	1Z0-064
Exam Product Version	Oracle Database 12c
Exam Price	USD $245 (Price may vary by country or by localized currency)
Duration	150 minutes
Number of Questions	84
Passing Score	62%
Recommended Training	Oracle Database 12c: Performance Management and Tuning Oracle Database Administration Learning Subscription Unlimited Product Learning Subscription
Format	Multiple Choice Questions (MCQ)
Recommended Training	Oracle Certified Expert Oracle Database 12c Performance Management and Tuning (OCE)
Recommended Practice	1Z0-064 Online Practice Exam

Oracle 1Z0-064 Syllabus Topics:

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