SQL Tuning, Resource Management, and Job Scheduling in Oracle Database 12c Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Expertise Level Overview/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).
Target Audience
Data warehouse administrator; database administrators; database designers; support engineer; technical administrator
Prerequisites
None
Expected Duration (hours)
2.7
Lesson Objectives SQL Tuning, Resource Management, and Job Scheduling in Oracle Database 12c
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
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
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
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
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
collect statistics, use the SQL Tuning Advisor, and create a simple resource plan in Oracle Database 12c
Course Number: od_dbre_a06_it_enus
Expertise Level
Intermediate