SQL Tuning
Oracle 12c
| Intermediate
- 10 videos | 53m 42s
- Includes Assessment
- Earns a Badge
Proper monitoring and tuning of databases significantly improves system performance. Learn how to use SQL tuning, optimizer statistics, and the range of SQL advisors included in Oracle Database 12c.
WHAT YOU WILL LEARN
-
Describe sql tuning and the optimizer statistics used in oracle database 12c
Describe the collection of optimizer statistics in oracle database 12c
Use the optimizer statistics console to set global preferences for optimizer statistics in oracle database 12c
Gather optimizer statistics manually and set optimizer statistics preferences in oracle database 12c
Describe concurrent statistics gathering in the oracle database 12c -
Describe concurrent statistics gathering and the use of sql plan directives in the oracle database 12c
Describe the sql advisors available in oracle database 12c
Describe and use the sql tuning advisor in oracle database 12c
Describe and use the sql access advisor in oracle database 12c
Describe and use the sql performance analyzer in oracle database 12c
IN THIS COURSE
-
1. SQL Tuning and Optimizer Statistics Overview5m 14sUpon completion of this video, you will be able to describe SQL tuning and the optimizer statistics used in Oracle Database 12c. FREE ACCESS
-
2. Optimizer Statistics Collection4m 27sUpon completion of this video, you will be able to describe the collection of optimizer statistics in Oracle Database 12c. FREE ACCESS
-
3. Viewing and Configuring Optimizer Statistics3m 13sIn this video, find out how to use the Optimizer Statistics Console to set global preferences for optimizer statistics in Oracle Database 12c. FREE ACCESS
-
4. Manually Gathering Optimizer Statistics6m 46sTo find out how to gather optimizer statistics manually and set optimizer statistics preferences in Oracle Database 12c, consult the Oracle documentation. FREE ACCESS
-
5. Gathering Concurrent Statistics1m 21sAfter completing this video, you will be able to describe concurrent statistics gathering in Oracle Database 12c. FREE ACCESS
-
6. Gather Concurrent Statistics and SQL Plan Directives7m 30sUpon completion of this video, you will be able to describe concurrent statistics gathering and the use of SQL plan directives in the Oracle Database 12c. FREE ACCESS
-
7. Overview of SQL Advisors3m 15sUpon completion of this video, you will be able to describe the SQL Advisors available in Oracle Database 12c. FREE ACCESS
-
8. SQL Tuning Advisor7m 53sAfter completing this video, you will be able to describe and use the SQL Tuning Advisor in Oracle Database 12c. FREE ACCESS
-
9. SQL Access Advisor7m 51sAfter completing this video, you will be able to describe and use the SQL Access Advisor in Oracle Database 12c. FREE ACCESS
-
10. SQL Performance Analyzer6m 14sUpon completion of this video, you will be able to describe and use the SQL Performance Analyzer in Oracle Database 12c. 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.
