Performance Tuning Methodology

Oracle 12c    |    Intermediate
  • 11 videos | 43m 25s
  • Includes Assessment
  • Earns a Badge
Rating 3.8 of 5 users Rating 3.8 of 5 users (5)
Broaden your knowledge of Oracle Database 12c performance tuning by examining a series of commonly occurring real-world performance problems and the typical solutions for those scenarios.

WHAT YOU WILL LEARN

  • Describe the oracle performance tuning methodology and common symptoms
    Describe common errors, their diagnosis, and solutions
    Describe how to diagnose and tune cpu-related waits
    Describe how to diagnose and tune redo-related waits
    Describe how to diagnose and tune waits related to the redo log
    Describe how to diagnose and tune waits related to the buffer cache
  • Describe how to diagnose and tune waits relates to shared and large pool
    Discuss best practices when creating and configuring tablespaces
    Describe how to diagnose and tune waits related to sql execution
    Describe the concept of direct i/o and related waits
    Discuss automated statistics gathering

IN THIS COURSE

  • Locked
    1.  Methodology and Common Symptoms
    6m 41s
    Upon completion of this video, you will be able to describe the Oracle performance tuning methodology and common symptoms. FREE ACCESS
  • Locked
    2.  Handling Errors
    4m 14s
    Upon completion of this video, you will be able to describe common errors, their diagnosis, and solutions. FREE ACCESS
  • Locked
    3.  CPU Waits
    3m 1s
    After completing this video, you will be able to describe how to diagnose and tune CPU-related issues. FREE ACCESS
  • Locked
    4.  Redo Waits
    4m 39s
    After completing this video, you will be able to describe how to diagnose and tune Redo-related waits. FREE ACCESS
  • Locked
    5.  Redo Log Waits
    3m 49s
    Upon completion of this video, you will be able to describe how to diagnose and tune waits related to the Redo Log. FREE ACCESS
  • Locked
    6.  Buffer Cache Waits
    3m 33s
    Upon completion of this video, you will be able to describe how to diagnose and tune waits related to the buffer cache. FREE ACCESS
  • Locked
    7.  Shared and Large Pool Waits
    3m 31s
    After completing this video, you will be able to describe how to diagnose and tune waits related to the Shared and Large Pools. FREE ACCESS
  • Locked
    8.  Tablespace Best Practices
    3m 3s
    In this video, find out how to discuss best practices for creating and configuring tablespaces. FREE ACCESS
  • Locked
    9.  SQL Execution Waits
    4m 19s
    After completing this video, you will be able to describe how to diagnose and tune waits related to SQL execution. FREE ACCESS
  • Locked
    10.  I/O Modes
    3m 48s
    After completing this video, you will be able to describe the concept of direct I/O and related waits. FREE ACCESS
  • Locked
    11.  Statistics Gathering
    2m 46s
    Find out how to discuss automated statistics gathering. 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 Tuning Problem SQL Statements
Rating 4.4 of 9 users Rating 4.4 of 9 users (9)
Course Oracle Database 12c R2 SQL: Conversion Functions & Conditional Expressions
Rating 4.7 of 42 users Rating 4.7 of 42 users (42)
Channel Oracle Database Administration

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Performance Tuning Summary
Rating 5.0 of 9 users Rating 5.0 of 9 users (9)
Course DEVASC: Configuring Devices with Bash, Python, & Ansible
Rating 4.5 of 6 users Rating 4.5 of 6 users (6)
Book Oracle Database 12c Release 2 Performance Tuning Tips and Techniques