Oracle 12C Performance Management & Tuning Exam Objective

Session 01: Basic Tuning Diagnostics

Session 02: Using Metrics and Alerts

Session 03: Using AWR-Based Tools

Session 04: Monitoring Applications

Session 05: Influencing the Optimizer

Session 06: Using SQL Performance Analyzer

Session 07: Using Database Replay

Session 08: Tuning the Buffer Cache

Session 09: Using Automatic Memory

Session 10: Using the Database Resource Manager

Session 11: Using Automatic Workload Repository

Session 12: Using Baselines

Session 13: Monitoring Real-Time Database Operation

Session 14: Identifying Problem SQL Statements

Session 15: Reducing the Cost of SQL Operations

Session 16: SQL Performance Management

Session 17: Tuning the Shared Pool

Session 18: Tuning PGA and Temporary Space

Session 19: Tuning I/O

Detailed Syllabus:

Session 01: Basic Tuning Diagnostics

Describe the time model
Explain wait events
Diagnose performance problems using V$ views

Session 02: Using Metrics and Alerts

Monitor performance using metric thresholds and alerts

Session 03: Using AWR-Based Tools

Diagnose performance issues using ADDM
Diagnose performance issues using ASH reports

Session 04: Monitoring Applications

Configure and use services to monitor database performance

Session 05: Influencing the Optimizer

Explain how statistics influence the optimizer
Configure parameters to influence the optimizer

Session 06: Using SQL Performance Analyzer

Use SQL Performance Analyzer to test the impact of database changes

Session 07: Using Database Replay

Use Database Replay to check impact of system change on performance

Session 08: Tuning the Buffer Cache

Diagnose and resolve performance issues related to the buffer cache

Session 09: Using Automatic Memory

Use and tune Automatic Shared Memory Management
Use and tune Automatic Memory Management

Session 10: Using the Database Resource Manager

Understand and configure the Database Resource Manager

Session 11: Using Automatic Workload Repository

Analyze database performance using AWR reports

Session 12: Using Baselines

Use AWR baselines to monitor performance

Session 13: Monitoring Real-Time Database Operation

Implement Real-Time Database Operation Monitoring

Session 14: Identifying Problem SQL Statements

Interpret execution plans
Use formatted output of SQL Trace or the optimizer trace to identify poorly performing SQL statements

Session 15: Reducing the Cost of SQL Operations

Use Automatic Segment Space Management to optimize space management
Use table compression
Diagnose and tune space related issues

Session 16: SQL Performance Management

Manage optimizer statistics
Use SQL Profiles and Advisors to tune SQL statements
Use SQL Plan Management to tune SQL statements

Session 17: Tuning the Shared Pool

Diagnose and resolve hard and soft parsing problems
Diagnose and resolve performance issues related to the shared pool

Session 18: Tuning PGA and Temporary Space

Diagnose and resolve performance issues related to PGA
Diagnose and resolve performance issues related to temporary tablespace

Session 19: Tuning I/O

Diagnose database I/O issues
Configure Automatic Storage Management (ASM) for maximum availability

If You Like What We Do Here On DatabaseConcept, You Should Consider:

Stay Connected to: Twitter | Facebook

Subscribe to our email updates: Sign Up Now

 

We are thankful for your support.