Measuring SQL Performance

Oracle 12c    |    Intermediate
  • 17 Videos | 1h 16m 21s
  • Includes Assessment
  • Earns a Badge
Likes 9 Likes 9
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

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SOLID & GRASP
Likes 3218 Likes 3218  
Likes 5 Likes 5