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 parsingdescribe cursor usage and specify further detail of SQL statement processingdescribe the process structures involved with DML and commit processingdefine the role of the Oracle optimizer and list ways of identifying poorly performing SQLdefine what an execution plan is and uses thereofdescribe how to generate and view an execution plandescribe how to read and understand an execution plan
-
list the dynamic performance views which provide detail about SQL execution plansdescribe the autotrace facility of SQL*Plusdescribe the SQL trace facility and use thereofdescribe how to format trace files with TKPROFlist TKPROF output and touch on producing optimizer trace filesexamine a bad SQL statement and gather information about it using AUTOTRACE and DBMS_XPLAN
IN THIS COURSE
-
1.Phases of SQL Statement Processing2m 43s
-
2.SQL Statement Parsing4m 39s
-
3.Processing a DML Statement3m 13s
-
4.The Oracle Optimizer3m 40s
-
5.Introduction to Execution Plans2m 37s
-
6.Viewing Execution Plans4m 13s
-
7.Reading an Execution Plan2m 44s
-
8.Execution Plan Details3m 32s
-
9.SQL*Plus Autotrace2m 37s
-
10.Extended SQL Tracing3m 44s
-
11.Formatting Trace Files with TKPROF3m 17s
-
12.TKPROF and Optimizer Tracing4m 6s
-
13.Exercise: Use AUTOTRACE and DBMS_XPLAN6m 11s
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.