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