SQL Diagnostics
Oracle 12c
| Intermediate
- 13 videos | 47m 16s
- Includes Assessment
- Earns a Badge
Increase your performance tuning knowledge by learning the basic phases of SQL processing and ways to extract detailed information about the actual execution of a SQL statement in Oracle Database 12c.
WHAT YOU WILL LEARN
-
Define the phases of sql statement processing, and the concepts of cursors and parsing
Describe cursor usage and specify further detail of sql statement processing
Describe the process structures involved with dml and commit processing
Define the role of the oracle optimizer and list ways of identifying poorly performing sql
Define what an execution plan is and uses thereof
Describe how to generate and view an execution plan
Describe how to read and understand an execution plan -
List the dynamic performance views which provide detail about sql execution plans
Describe the autotrace facility of sql*plus
Describe the sql trace facility and use thereof
Describe how to format trace files with tkprof
List tkprof output and touch on producing optimizer trace files
Examine a bad sql statement and gather information about it using autotrace and dbms_xplan
IN THIS COURSE
-
1. Phases of SQL Statement Processing2m 43sIn this video, you will learn how to define the phases of SQL statement processing, and the concepts of cursors and parsing. FREE ACCESS
-
2. SQL Statement Parsing4m 39sUpon completion of this video, you will be able to describe cursor usage and specify further detail of SQL statements processing. FREE ACCESS
-
3. Processing a DML Statement3m 13sUpon completion of this video, you will be able to describe the process structures involved with DML and commit processing. FREE ACCESS
-
4. The Oracle Optimizer3m 40sIn this video, you will learn how to define the role of the Oracle optimizer and list ways to identify poorly performing SQL. FREE ACCESS
-
5. Introduction to Execution Plans2m 37sIn this video, learn how to define what an execution plan is and how to use it. FREE ACCESS
-
6. Viewing Execution Plans4m 13sUpon completion of this video, you will be able to describe how to generate and view an execution plan. FREE ACCESS
-
7. Reading an Execution Plan2m 44sAfter completing this video, you will be able to describe how to read and understand an execution plan. FREE ACCESS
-
8. Execution Plan Details3m 32sUpon completion of this video, you will be able to list the dynamic performance views that provide detail about SQL execution plans. FREE ACCESS
-
9. SQL*Plus Autotrace2m 37sAfter completing this video, you will be able to describe the autotrace feature of SQL*Plus. FREE ACCESS
-
10. Extended SQL Tracing3m 44sAfter completing this video, you will be able to describe the SQL trace facility and how to use it. FREE ACCESS
-
11. Formatting Trace Files with TKPROF3m 17sUpon completion of this video, you will be able to describe how to format trace files using TKPROF. FREE ACCESS
-
12. TKPROF and Optimizer Tracing4m 6sAfter completing this video, you will be able to list TKPROF output and touch on producing optimizer trace files. FREE ACCESS
-
13. Exercise: Use AUTOTRACE and DBMS_XPLAN6m 11sDuring this video, you will learn how to examine a SQL statement that is not working correctly and gather information about it using AUTOTRACE and DBMS_XPLAN. 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.
