Measuring SQL Performance
Oracle 12c
| Intermediate
- 17 Videos | 1h 8m 21s
- Includes Assessment
- Earns a Badge
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 testingusing SQL performance analyzercreate and compare SQL performance analyzer tasksuse the SQL tuning advisor to assist in tuning regressing SQL statementsdescribe the PL/SQL functions used to manipulate the SQL performance analyzerdescribe the fundamental methods with which to maintain SQL performancedescribe the options available when configuring optimizer statisticsdiscuss the concept of deferred statisticsdiscuss the concept of automatic SQL tuning
-
discuss the concept of the SQL tuning advisordiscuss the concept of the SQL access advisordiscuss the concept and architecture around SQL plan baselinesdescribe how SQL plan baselines are created and evolve over timedescribe adaptive SQL plan managementdiscuss how SQL plan selection works and list scenarios under which it comes into playlist the methods available to configure the SPM infrastructure and show the interaction with enterprise manageruse the DBMS_SPM package to fix a particular execution plan for a given SQL statement
IN THIS COURSE
-
1.Real Application Testing2m 38s
-
2.SQL Performance Analyzer4m 21s
-
3.SQL Performance Analyzer Tasks3m 29s
-
4.Preventing Regressing SQL Statements3m 20s
-
5.SQL Performance Analyzer Example2m 43s
-
6.Maintaining SQL Performance3m 38s
-
7.Managing Optimizer Statistics3m 48s
-
8.Deferred Statistics Publishing2m 54s
-
9.Automatic SQL Tuning5m 18s
-
10.SQL Tuning Advisor4m 23s
-
11.SQL Access Advisor4m 1s
-
12.SQL Plan Baselines5m 12s
-
13.The Lifecycle of SQL Plan Baselines4m 20s
-
14.Adaptive SQL Plan Management4m 29s
-
15.SQL Plan Manageability4m 49s
-
16.SPM Configuration and Enterprise Manager2m 45s
-
17.Exercise: Implement Plan Stability with SPM6m 14s
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.