TRENDS is authorized to promote and deliver Oracle courses in partnership with TechEdge Solutions. EZY Corporation logo and Oracle logo are registered trademarks of EZY Corporation and Oracle respectively. All rights reserved.

Oracle Database 12c: Performance Management and Tuning Ed 1

Schedule

Start End Duration Location Details

Course Details

Oracle Database 12c: Performance Management and Tuning Ed 1 

Course code: OD12PMT1

Duration: 5 Days

Prerequisite:

Required Prerequisites

•  Oracle Database 12c: Administration Workshop Ed 2

Suggested Prerequisite

•   Oracle Database 12c: Install and Upgrade Workshop Ed 1

Course Description:

In the Oracle Database 12c: Performance Management and Tuning course, learn about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues. In this course, you will be introduced to Oracle Database Cloud Service.

Course Objectives:

After taking this course, you should be able to:

•    Use the Oracle Database tuning methodology appropriate to the available tools
•    Utilize database advisors to proactively tune an Oracle Database Instance
•    Use the tools based on the Automatic Workload Repository to tune the database
•    Diagnose and tune common SQL related performance problems
•    Diagnose and tune common Instance related performance problems
•    Use Enterprise Manager performance-related pages to monitor an Oracle Database
•    Gain an understanding of the Oracle Database Cloud Service

Intended Audience:

•    Administrator
•    Database Administrator

Course Outlines:

•    Introduction
•    Basic Tuning Diagnostics
•    Using Automatic Workload Repository
•    Defining the Scope of Performance Issues
•    Using Metrics and Alerts
•    Using Baselines
•    Using AWR-Based Tools
•    Real-Time Database Operation Monitoring
•    Monitoring Applications
•    Identifying Problem SQL Statements
•    Influencing the Optimizer
•    Reducing the Cost of SQL Operations
•    Using SQL Performance Analyzer
•    SQL Performance Management
•    Using Database Replay
•    Tuning the Shared Pool
•    Tuning the Buffer Cache
•    Tuning PGA and Temporary Space
•    Automatic Memory
•    Performance Tuning Summary with Waits
•    Oracle Database Cloud Service: Overview