Oracle 1Z0-064 Certification Exam Syllabus

1Z0-064 Syllabus, 1Z0-064 Dumps PDF, Oracle OCE Dumps, 1Z0-064 Dumps Free Download PDF, Oracle Database 12c OCE Dumps, 1Z0-064 Latest Dumps Free DownloadYou can use this exam guide to collect all the information about Oracle Database 12c Performance Management and Tuning (1Z0-064) certification. The Oracle 1Z0-064 certification is mainly targeted to those candidates who has some experience or exposure of Oracle Database 12c and want to flourish their career with Oracle Certified Expert Oracle Database 12c Performance Management and Tuning (OCE) credential. The Oracle Database 12c Performance Management and Tuning certification exam validates your understanding of the Oracle Database 12c technology and sets the stage for your future progression. Your preparation plan for Oracle 1Z0-064 Certification exam should include hands-on practice or on-the-job experience performing the tasks described in following Certification Exam Topics table.

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 (Pricing may vary by country or by localized currency)
Duration 150
Number of Questions 84
Passing Score 62%
Validated Against Exam has been validated for product version 12.1.0.1.0
Format Multiple Choice
Recommended Training Oracle Database 12c: Performance Management and Tuning
Schedule Exam Pearson VUE - Oracle
Recommended Practice 1Z0-064 Online Practice Exam

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

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

Rating: 5 / 5 (35 votes)