Oracle 12c Performance Tuning: Application Monitoring and SQL Diagnostics

Database Administrators, Application Developers, Technical Consultants


Expected Duration
85 minutes

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


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





Multi-license discounts available for Annual and Monthly subscriptions.