Certification Provider: Oracle
Exam Name: Oracle Database 12c: Performance Management and Tuning
Number of questions in our database: 119
1Z0-064 Exam Official Topics:
- Topic 1: Diagnose and resolve performance issues related to temporary tablespace/ Diagnose performance problems using V$ views
- Topic 2: Understand and configure the Database Resource Manager/ Analyze database performance using AWR reports
- Topic 3: Diagnose and resolve performance issues related to PGA/ Monitor performance using metric thresholds and alerts
- Topic 4: Diagnose and resolve performance issues related to the buffer cache/ Use AWR baselines to monitor performance
- Topic 5: Use Database Replay to check impact of system change on performance/ Diagnose performance issues using ASH reports
- Topic 6: Use Automatic Segment Space Management to optimize space management/ Diagnose performance issues using ADDM
- Topic 7: Configure parameters to influence the optimizer/ Implement Real-Time Database Operation Monitoring
- Topic 8: Use SQL Performance Analyzer to test the impact of database changes/ Configure and use services to monitor database performance
- Topic 9: Diagnose and resolve performance issues related to the shared pool/ Monitoring Real-Time Database Operation
- Topic 10: Use SQL Profiles and Advisors to tune SQL statements/ Explain how statistics influence the optimizer
- Topic 11: