SQL Diagnostics
Oracle 12c
| Intermediate
- 13 Videos | 53m 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 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.
