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 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
-
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.
