SQL Tuning, Resource Management, and Job Scheduling in Oracle Database 12c

Data warehouse administrator; database administrators; database designers; support engineer; technical administrator

Prerequisite
None

Expected Duration
159 minutes

Description
Proper monitoring and tuning of databases significantly improves system performance. In this course, you’ll learn how to use SQL tuning, optimizer statistics, and the range of SQL advisors included in Oracle Database 12c. You’ll also learn how to manage resources to optimize performance and how to use the Oracle Scheduler to create and schedule jobs. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c Installation and Administration exam (1Z0-062).

Objective

SQL Tuning and Optimizer Statistics

  • start the course
  • describe SQL tuning and the optimizer statistics used in Oracle Database 12c
  • describe the collection of optimizer statistics in Oracle Database 12c
  • use the Optimizer Statistics Console to set global preferences for optimizer statistics in Oracle Database 12c
  • gather optimizer statistics manually and set optimizer statistics preferences in Oracle Database 12c
  • describe concurrent statistics gathering in the Oracle Database 12c
  • view statistics information and the use of SQL plan directives in the Oracle Database 12c

SQL Advisors

  • describe the SQL Advisors available in Oracle Database 12c
  • describe and use the SQL Tuning Advisor in Oracle Database 12c
  • describe and use the SQL Access Advisor in Oracle Database 12c
  • describe and use the SQL Performance Analyzer in Oracle Database 12c

Database Resource Manager

  • describe the uses of the Database Resource Manager in Oracle Database 12c
  • describe the default Resource Manager plan in Oracle Database 12c
  • create simple and complex resource plans in Oracle Database 12c
  • specify resource plan directives and allocate plan resources in Oracle Database 12c
  • describe the Active Session Pool mechanism, specify thresholds, and set idle timeouts in Oracle Database 12c
  • limit CPU utilization at the database and server levels, and monitor instance caging in Oracle Database 12c
  • track runaway queries and manage the mapping of sessions to resource consumer groups in Oracle Database 12c
  • monitor Resource Manager statistics in Oracle Database 12c

Oracle Scheduler

  • describe how to simplify management tasks using the Oracle Scheduler in Oracle Database 12c
  • describe the components of the Scheduler in Oracle Database 12c
  • describe the use of time and event-based schedules in the Oracle Database 12c
  • describe the creation of time and event-based jobs in the Oracle Database 12c
  • configure e-mail notifications and job chains using Oracle Scheduler in Oracle Database 12c

Advanced Scheduler Features

  • describe job classes and job prioritization in Oracle Database 12c
  • create a job array, create a file watcher, and configure file arrival events using Oracle Scheduler in Oracle Database 12c
  • schedule remote database jobs and view Oracle Scheduler metadata in Oracle Database 12c

Practice: SQL Tuning and Resource Management

  • collect statistics, use the SQL Tuning Advisor, and create a simple resource plan in Oracle Database 12c

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.