Oracle 12c Performance Tuning: Application Monitoring and SQL Diagnostics


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/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).

Target Audience
Database Administrators, Application Developers, Technical Consultants

Prerequisites
None

Expected Duration (hours)
1.4

Lesson Objectives

Oracle 12c Performance Tuning: Application Monitoring and SQL Diagnostics

  • 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
  • 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
  • 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
  • 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
  • examine a bad SQL statement and gather information about it using AutoTrace and DBMS_XPLAN

    • Course Number:
    od_pmte_a04_it_enus

    Expertise Level
    Intermediate