Measuring SQL Performance

Oracle 12c    |    Intermediate
  • 17 videos | 1h 8m 21s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 10 users Rating 4.5 of 10 users (10)
Once poorly performing SQL is identified and changes are proposed, you need to ensure that they will yield the desired effect. Discover how tools such as the SQL Performance Analyzer and SQL Tuning Advisor can be used to achieve this goal.

WHAT YOU WILL LEARN

  • Using real application testing
    Using sql performance analyzer
    Create and compare sql performance analyzer tasks
    Use the sql tuning advisor to assist in tuning regressing sql statements
    Describe the pl/sql functions used to manipulate the sql performance analyzer
    Describe the fundamental methods with which to maintain sql performance
    Describe the options available when configuring optimizer statistics
    Discuss the concept of deferred statistics
    Discuss the concept of automatic sql tuning
  • Discuss the concept of the sql tuning advisor
    Discuss the concept of the sql access advisor
    Discuss the concept and architecture around sql plan baselines
    Describe how sql plan baselines are created and evolve over time
    Describe adaptive sql plan management
    Discuss how sql plan selection works and list scenarios under which it comes into play
    List the methods available to configure the spm infrastructure and show the interaction with enterprise manager
    Use the dbms_spm package to fix a particular execution plan for a given sql statement

IN THIS COURSE

  • Locked
    1.  Real Application Testing
    2m 38s
    Learn how to use real application testing. FREE ACCESS
  • Locked
    2.  SQL Performance Analyzer
    4m 21s
    Find out how to use the SQL performance analyzer. FREE ACCESS
  • Locked
    3.  SQL Performance Analyzer Tasks
    3m 29s
    In this video, you will learn how to create and compare SQL performance analyzer tasks. FREE ACCESS
  • Locked
    4.  Preventing Regressing SQL Statements
    3m 20s
    In this video, you will learn how to use the SQL tuning advisor to assist in tuning SQL statements that are regressing. FREE ACCESS
  • Locked
    5.  SQL Performance Analyzer Example
    2m 43s
    Upon completion of this video, you will be able to describe the PL/SQL functions used to manipulate the SQL performance analyzer. FREE ACCESS
  • Locked
    6.  Maintaining SQL Performance
    3m 38s
    Upon completion of this video, you will be able to describe the fundamental methods for maintaining SQL performance. FREE ACCESS
  • Locked
    7.  Managing Optimizer Statistics
    3m 48s
    After completing this video, you will be able to describe the options available when configuring optimizer statistics FREE ACCESS
  • Locked
    8.  Deferred Statistics Publishing
    2m 54s
    Learn how to discuss the concept of deferred statistics. FREE ACCESS
  • Locked
    9.  Automatic SQL Tuning
    5m 18s
    In this video, you will learn how to discuss the concept of automatic SQL tuning. FREE ACCESS
  • Locked
    10.  SQL Tuning Advisor
    4m 23s
    To discuss the concept of the SQL tuning advisor, please consult the following resources. FREE ACCESS
  • Locked
    11.  SQL Access Advisor
    4m 1s
    In this video, you will learn how to discuss the concept of the SQL access advisor. FREE ACCESS
  • Locked
    12.  SQL Plan Baselines
    5m 12s
    In this video, you will discuss the concept and architecture around SQL plan baselines. FREE ACCESS
  • Locked
    13.  The Lifecycle of SQL Plan Baselines
    4m 20s
    After completing this video, you will be able to describe how SQL plan baselines are created and how they evolve over time. FREE ACCESS
  • Locked
    14.  Adaptive SQL Plan Management
    4m 29s
    Upon completion of this video, you will be able to describe how adaptive SQL plan management works. FREE ACCESS
  • Locked
    15.  SQL Plan Manageability
    4m 49s
    In this video, you will discuss how SQL plan selection works and list scenarios under which it is used. FREE ACCESS
  • Locked
    16.  SPM Configuration and Enterprise Manager
    2m 45s
    After completing this video, you will be able to list the methods available to configure the SPM infrastructure and show the interaction with enterprise manager. FREE ACCESS
  • Locked
    17.  Exercise: Implement Plan Stability with SPM
    6m 14s
    Learn how to use the DBMS_SPM package to fix a particular execution plan for a given SQL statement. 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

Book Database Performance at Scale: A Practical Guide
Book Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights
Book Be Data Analytical: How to Use Analytics to Turn Data into Value

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Maintaining SQL Performance
Rating 4.7 of 7 users Rating 4.7 of 7 users (7)
Course Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Rating 4.6 of 255 users Rating 4.6 of 255 users (255)
Course SQL Diagnostics
Rating 4.2 of 10 users Rating 4.2 of 10 users (10)