Introduction to Performance Tuning

Oracle 12c    |    Intermediate
  • 15 videos | 29m 11s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 32 users Rating 4.5 of 32 users (32)
There are many methodologies for troubleshooting performance problems in Oracle Database 12c. Learn about performance management techniques, including tuning goals and objectives, and working with waits, events, classes, and statistics.

WHAT YOU WILL LEARN

  • Define the components of performance management
    Identify who is responsible for performance management of the oracle database
    Describe the oracle tuning methodology
    Describe effective tuning goals
    List the steps of a general tuning session
    Identify tuning objectives
    List the top timed events
    Define the concept of db time
  • Describe cpu and wait time tuning dimensions
    Define the time model
    Work with the dynamic performance views
    Describe database wait events
    Describe database wait classes
    Use sql to display wait event statistics
    Describe commonly observed wait events

IN THIS COURSE

  • Locked
    1.  Introduction to Performance Management
    2m 22s
    In this video, you will learn how to define the components of performance management. FREE ACCESS
  • Locked
    2.  Who Does Performance Management
    1m 50s
    Find out how to identify who is responsible for performance management of the Oracle database. FREE ACCESS
  • Locked
    3.  Tuning Methodology
    1m 48s
    Upon completion of this video, you will be able to describe the oracle tuning methodology. FREE ACCESS
  • Locked
    4.  Effective Tuning Goals
    2m 14s
    After watching this video, you will be able to describe effective tuning goals. FREE ACCESS
  • Locked
    5.  General Tuning Session
    1m 10s
    After completing this video, you will be able to list the steps of a general tuning session. FREE ACCESS
  • Locked
    6.  Tuning Objectives
    2m 13s
    During this video, you will learn how to identify tuning objectives. FREE ACCESS
  • Locked
    7.  Top Timed Events
    1m 53s
    Upon completion of this video, you will be able to list the top timed events. FREE ACCESS
  • Locked
    8.  DB Time
    1m 42s
    Find out how to define the concept of database time. FREE ACCESS
  • Locked
    9.  CPU and Wait Time Tuning Dimensions
    1m 36s
    After completing this video, you will be able to describe CPU and wait time tuning dimensions. FREE ACCESS
  • Locked
    10.  Time Model Overview
    2m 13s
    In this video, find out how to define the time model. FREE ACCESS
  • Locked
    11.  Dynamic Performance Views
    2m 41s
    In this video, you will learn how to work with the dynamic performance views. FREE ACCESS
  • Locked
    12.  Wait Events
    1m 58s
    Upon completion of this video, you will be able to describe database wait events. FREE ACCESS
  • Locked
    13.  Wait Classes
    1m 55s
    After completing this video, you will be able to describe the database wait classes. FREE ACCESS
  • Locked
    14.  Wait Event Statistics
    1m 38s
    In this video, find out how to use SQL to display statistics for wait events. FREE ACCESS
  • Locked
    15.  Commonly Observed Wait Events
    1m 59s
    Upon completion of this video, you will be able to describe commonly observed wait events. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Technical Program Management: Assessing Performance & Benefits Delivery
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Channel Oracle Database 12c Administrator Certified Associate
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Book Database Performance at Scale: A Practical Guide

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Agile Foundations: Fundamentals
Rating 4.4 of 1482 users Rating 4.4 of 1482 users (1482)
Course Tuning Problem SQL Statements
Rating 4.4 of 9 users Rating 4.4 of 9 users (9)
Book The Project Manager's Guide to Mastering Agile: Principles and Practices for an Adaptive Approach, Second Edition