SQL Diagnostics

Oracle 12c    |    Intermediate
  • 13 Videos | 47m 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.

YOU MIGHT ALSO LIKE

BOOK SQL for Data Scientists: A Beginner's Guide for Building Data Sets for Analysis
BOOK PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries
BOOK High Performance SQL Server: Consistent Response for Mission-Critical Applications, Second Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SOLID & GRASP
Likes 4617 Likes 4617  
COURSE Performance Tuning
Likes 33 Likes 33  
COURSE Oracle Database Instance Overview
Likes 49 Likes 49