1Z0-064 Practice: Oracle 12c Performance Management & Tuning

Course details

Passing this exam is required to earn - Oracle Certified Expert, Oracle Database 12c: Performance Management and Tuning

EXAM DETAILS:

• Duration: 150 min
• No of questions: 84
• Passing score: 62%
• Exam price: US$ 245

EXAM 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