• Online, Self-Paced
Course Description

Oracle Database 12C includes services that organize work execution within the database, and make execution that much more manageable, measurable, tunable, and recoverable. This course covers these services as well as the basic phases of SQL processing, and ways to extract detailed information about the actual execution of a SQL statement. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c: Performance Management and Tuning exam (1ZO-064).

Learning Objectives

Monitoring Applications

  • start the course
  • list the characteristics of a service
  • list the attributes and types of services
  • describe how services are created and managed
  • identify how to work with services
  • specify how services integrate with database resource management


Advanced Application Monitoring

  • use EM Cloud Control to show how services work in conjunction with the Oracle Scheduler
  • describe how services can be integrated with metric thresholds
  • describe service aggregation and tracing
  • describe how to configure service aggregation
  • list the dictionary views relevant to service performance


SQL Processing

  • define the phases of SQL statement processing, and the concepts of cursors and parsing
  • explain SQL binding, executing, and fetching
  • describe the process structures involved with DML and commit processing
  • define the role of the Oracle optimizer
  • define what an execution plan is and uses thereof
  • describe how to generate and view an execution plan


Advanced SQL Diagnostics

  • describe how to read and understand an execution plan
  • list the dynamic performance views which provide detail about SQL execution plans
  • use the SQL*Plus Autotrace facility
  • use extended SQL tracing
  • describe how to format trace files with TKPROF
  • interpret TKPROF output


Practice : Advanced SQL Diagnostics

  • examine a bad SQL statement and gather information about it using AutoTrace and DBMS_XPLAN


Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Administration
  • Systems Development