SQL Diagnostics

Oracle 12c    |    Intermediate
  • 13 Videos | 53m 16s
  • Includes Assessment
  • Earns a Badge
Likes 14 Likes 14
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

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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 5 Likes 5  
Likes 16 Likes 16  
COURSE SQL Developer
Likes 285 Likes 285