Summer-Ready Savings: Find the Training Course You Need at a Price You'll Love

closeClose

Oracle Database: Performance Management and Tuning

  • Tuition USD $3,860 - $4,070
  • Reviews star_rate star_rate star_rate star_rate star_half 346 Ratings
  • Course Code OUDATA-PMT
  • Duration 5 days
  • Available Formats Virtual, Classroom
  • Use the Oracle tuning methodology
  • Use Oracle-supplied tools for monitoring and diagnosing SQL and instance tuning issues
  • Use database advisors to proactively correct performance problems
  • Identify problem SQL statements 
  • Tune SQL performance problems
  • Monitor instance performance by using Enterprise Manager 
  • Tune instance components by primarily using instance parameters

 

 

Skills Gained

  • 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

Who Can Benefit

  • Administrator
  • Database Administrator

Prerequisites

Suggested Prerequisite

  • Oracle Database 12c R2: Install and Upgrade Workshop Ed 2
  • Familiarity with Oracle Database installation
  • Familiarity with Oracle Database configuration concepts

Required Prerequisite

  • Oracle Database 18c: Administration Workshop Ed 1
  • Basic knowledge of Linux operating system
  • A working knowledge of SQL and PL/SQL packages
  • Basic understanding of Oracle Database architecture
  • Familiarity with basic database monitoring procedures

Course Details

Topics

  • 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
  • Types of Tuning
  • Tuning Methodology
  • Effective Tuning Goals
  • General Tuning Session

Basic Tuning Diagnostics

  • Performance Tuning Features and Tools
  • Top Timed Events
  • DB Time
  • CPU and Wait Time Tuning Dimensions
  • Time Model
  • Statistic Levels
  • Wait Events
  • Alert Log and Trace Files

Using Automatic Workload Repository

  • Automatic Workload Repository Data
  • AWR Administration
  • AWR in a Multitenant Architecture Database
  • Snapshots
  • Reports
  • Compare Periods
  • PDB-Level Snapshot Views

Defining the Scope of Performance Issues

  • Determining Tuning Priorities
  • Top SQL Repors
  • Common Tuning Problems
  • Tuning During the Life Cycle
  • ADDM Tuning Session
  • Performance Versus Business Requirements
  • Performance Tuning Resources

Using Metrics and Alerts

  • Typical Delta Tools
  • Oracle Database Metrics
  • Statistic Histograms
  • Server-Generated Alerts
  • Alert Usage Model
  • Setting Thresholds

Using Baselines

  • Comparative Performance Analysis with AWR Baselines
  • Types of Baselines
  • Creating AWR Baselines
  • Managing Baselines by Using the DBMS_WORKLOAD_REPOSITORY PL/SQL Package
  • Performance Monitoring and Baselines
  • Defining Alert Thresholds Using a Static Baseline
  • Configuring a Basic Set of Thresholds

Using AWR-Based Tools

  • Automatic Maintenance Tasks
  • ADDM Performance Monitoring
  • AWR and ADDM Behavior in a Multitenant Architecture Database
  • Using Compare Periods ADDM
  • Active Session History
  • Emergency Monitoring
  • Real-time ADDM

Real-Time Database Operation Monitoring

  • Scope of a Composite Database Operation
  • Database Operation Concepts
  • Identifying a Database Operation
  • Enabling Monitoring of Database Operations
  • Monitoring Load Database Operations
  • Reporting Database Operations by Using Functions
  • Database Operation Tuning

Monitoring Applications

  • Creating Services
  • Using Services with Client Applications
  • Using Services with the Resource Manager
  • Using Enterprise Manager to Manage Consumer Group Mappings
  • Using Services with Metric Thresholds
  • Service Aggregation and Tracing
  • Client Identifier Aggregation and Tracing
  • trcsess Utility

Identifying Problem SQL Statements

  • SQL Statement Processing Phases
  • Role of the Oracle Optimizer
  • Identifying Bad SQL
  • Uses of Execution Plans
  • Reading an Execution Plan
  • SQL Trace Facility
  • Generate an Optimizer Trace

Influencing the Optimizer

  • Functions of the Query Optimizer
  • Selectivity,Cardinality and Cost
  • Optimizer Statistics
  • Extended Statistics
  • Adaptive Execution Plans
  • Using Hints
  • Access Paths
  • Join Operations and Sort Operations

Reducing the Cost of SQL Operations

  • Index Maintenance
  • SQL Access Advisor
  • Table Reorganization Methods
  • Space Management
  • Extent Management
  • Migration and Chaining
  • Shrinking Segments
  • Data Compression

Using SQL Performance Analyzer

  • Capturing the SQL Workload
  • Creating a SQL Performance Analyzer Task
  • Comparison Report
  • Tuning Regressing Statements
  • SQL Tuning Recommendations
  • Preventing Regressions
  • Tuning Regressed SQL Statements

SQL Performance Management

  • Maintaining Optimizer Statistics
  • Setting Statistic Preferences
  • Using the Optimizer Statistics Advisor
  • Deferred Statistics Publishing
  • Automatic SQL Tuning
  • SQL Tuning Advisor
  • Using the SQL Access Advisor
  • SQL Plan Management

Using Database Replay

  • Capture Considerations
  • Replay Considerations
  • Replay Analysis
  • Database Replay Packages
  • Calibrating Replay Clients

Tuning the Shared Pool

  • Shared Pool Architecture
  • The Library Cache
  • Latch and Mutex
  • Diagnostic Tools for Tuning the Shared Pool
  • Sizing the Shared Pool
  • Avoiding Fragmentation
  • Data Dictionary Cache
  • SQL Query Result Cache

Tuning the Buffer Cache

  • Database Buffers
  • Symptoms of a Buffer Cache Issue
  • Solutions for Buffer Cache Issues
  • Memoptimized Rowstore
  • Automatically Tuned Multiblock Reads
  • Database Smart Flash Cache
  • Force Full Database Caching
  • Flushing the Buffer Cache

Tuning PGA and Temporary Space

  • SQL memory usage
  • SQL Memory Manager
  • Configuring Automatic PGA Memory
  • Managing PGA for PDBs
  • PGA Target Advice Statistics and Histograms
  • Temporary Tablespace Management
  • Temporary Tablespace Group
  • Shrinking a Temporary Tablespace

Automatic Memory

  • Dynamic SGA
  • Memory Advisories
  • Automatic Shared Memory Management
  • Memory Broker Architecture
  • Memory Management for CDBs
  • Managing SGA for PDBs
  • SGA Advisor
  • Automatic Memory Management

Performance Tuning Summary with Waits

  • Automatic Checkpoint Tuning
  • Sizing the Redo Log Buffer
  • Sizing Redo Log Files
  • Increasing the Performance of Archiving
  • General Tablespace and Undo Tablespace Best Practices
  • SQL Execution Related Waits
  • Internal Fragmentation Considerations
  • I/O Modes

How do I enroll?

A comprehensive listing of ExitCertified courses can be found here. You can register directly for the required course/location when you select "register". If you have any questions or prefer to speak with an ExitCertified education consultant directly, please submit your query here. A representative will contact you shortly.

How do I pay for a class?

You can pay at the time of registration using credit card (Mastercard/Visa/American Express) cheque or PO.

What if I have training credits?

ExitCertified honors all savings programs from the partners we work with. ExitCertified also offers training credits across multiple partners through our FLEX Account.

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Lunchtime?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

ExitCertified consistently delivers excellent courses with highly knowledgeable instructors and robust course content.

Attended a Power BI class in McLean with this company. The instructor (Mike Staves) was very good and attentive to the groups' learning needs. The facility was very good and the staff was more than accommodating.

Awesome instructor with in-depth knowledge and the ability to present in a meaningful & understandable way. This course will provide a solid foundation within DataStage that can be used immediately. I highly recommend this course.

The course is perfectly designed with material and labs to get hands on experience on AWS, nicely done!

The instructor was very good. He had a terrific temperament and never seemed to get tired. He was very patient with some of the participants and their lack of experience.

16 options found

undo
  • Jul 20, 2020 Jul 24, 2020 (5 days)
    Location
    Toronto, DC
    Language
    English
    Time
    09:00 AM 17:00 PM EST
    Enroll
    Enroll
  • Jul 20, 2020 Jul 24, 2020 (5 days)
    Location
    Virtual
    Language
    English
    Time
    09:00 AM 17:00 PM GMT
    Enroll
    Enroll
  • Jul 27, 2020 Jul 31, 2020 (5 days)
    Location
    Virtual
    Language
    English
    Time
    08:00 AM 16:00 PM PST
    Enroll
    Enroll
  • Aug 24, 2020 Aug 28, 2020 (5 days)
    Location
    Atlanta, GA
    Language
    English
    Time
    09:00 AM 17:00 PM EST
    Enroll
    Enroll
  • Aug 24, 2020 Aug 28, 2020 (5 days)
    Location
    Virtual
    Language
    English
    Time
    09:00 AM 17:00 PM PST
    Enroll
    Enroll
  • Sep 14, 2020 Sep 18, 2020 (5 days)
    Location
    Edison, NJ
    Language
    English
    Time
    09:00 AM 17:00 PM EST
    Enroll
    Enroll
  • Sep 14, 2020 Sep 18, 2020 (5 days)
    Location
    Edison, NJ
    Language
    English
    Time
    9:00AM 5:00PM EDT
    Enroll
    Enroll
  • Sep 14, 2020 Sep 18, 2020 (5 days)
    Location
    Toronto, DC
    Language
    English
    Time
    09:00 AM 17:00 PM EST
    Enroll
    Enroll
  • Sep 28, 2020 Oct 2, 2020 (5 days)
    Location
    Virtual
    Language
    English
    Time
    10:00 AM 18:00 PM PST
    Enroll
    Enroll
  • Oct 5, 2020 Oct 9, 2020 (5 days)
    Location
    Virtual
    Language
    English
    Time
    11:30 AM 19:30 PM CST
    Enroll
    Enroll
  • Oct 19, 2020 Oct 23, 2020 (5 days)
    Location
    Virtual
    Language
    English
    Time
    08:00 AM 16:00 PM GMT
    Enroll
    Enroll
  • Oct 26, 2020 Oct 30, 2020 (5 days)
    Location
    Virtual
    Language
    English
    Time
    06:00 AM 14:00 PM PST
    Enroll
    Enroll
  • Nov 16, 2020 Nov 20, 2020 (5 days)
    Location
    King of Prussia, PA
    Language
    English
    Time
    09:00 AM 17:00 PM EST
    Enroll
    Enroll
  • Nov 16, 2020 Nov 20, 2020 (5 days)
    Location
    Edison, NJ
    Language
    English
    Time
    09:00 AM 17:00 PM EST
    Enroll
    Enroll
  • Nov 23, 2020 Nov 27, 2020 (5 days)
    Location
    Toronto, DC
    Language
    English
    Time
    09:00 AM 17:00 PM EST
    Enroll
    Enroll
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward