Oracle 1Z0-064 Certification Exam Syllabus

1Z0-064 Syllabus, 1Z0-064 Latest Dumps PDF, Oracle Database Performance Management and Tuning Dumps, 1Z0-064 Free Download PDF Dumps, Database Performance Management and Tuning DumpsYou can use this Oracle 1Z0-064 exam study guide to collect all the information about the Oracle Database 12c - Performance Management and Tuning exam. The Oracle 1Z0-064 certification exam is mainly targeted to those candidates who have some experience or exposure to Oracle Database 12c technology and want to flourish their career with Oracle Certified Expert Oracle Database 12c Performance Management and Tuning (OCE) credential.

The Oracle 1Z0-064 certification exam validates your understanding of the Oracle Database 12c technology and sets the stage for your future progression. Your preparation plan for Oracle Database 12c - Performance Management and Tuning Certification exam should include hands-on practice or on-the-job experience performing the tasks described in following certification exam syllabus topics.

Oracle 1Z0-064 Exam Details:

Exam Name Oracle Database 12c - Performance Management and Tuning
Exam Code 1Z0-064
Exam Price USD $245 (Price may vary by country or by localized currency)
Duration 150 minutes
Number of Questions 84
Passing Score 62%
Format Multiple Choice Questions (MCQ)
Recommended Training Oracle Database 12c: Performance Management and Tuning
Oracle Database Learning Subscription
Unlimited Learning Subscription - All Technology
Schedule Exam Pearson VUE
Sample Questions 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

The Oracle Database Performance Management and Tuning Certification Program certifies candidates on skills and knowledge related to Oracle Database 12c products and technologies. The Oracle 1Z0-064 is granted based on a combination of passing exams, training, and performance-based assignments, depending on the level of certification. Oracle Database 12c - Performance Management and Tuning certification is a real benchmark of experience and expertise that helps you stand out in a crowd among employers. To ensure success, Oracle recommends combining education courses, practice exams, and hands-on experience to prepare for your Oracle Certified Expert Oracle Database 12c Performance Management and Tuning (OCE) certification exam as questions will test your ability to apply the knowledge you have gained in hands-on practice or professional experience.

Rating: 4.8 / 5 (32 votes)