Oracle Database 12c: Resource Manager & Scheduler

Course Description

One of the most important and oftentimes underutilized database features is that of the Oracle Database 12c Resource Manager. This is an essential facility for achieving optimum database performance. While this facility could be considered as highly recommended though optional in a traditional Oracle database configuration, in a multi-tenant configuration of pluggable databases enclosed within a container database, the use of the Oracle Database 12c Resource Manager can really be considered as mandatory. This training guide book provides conceptual background information on the advantages of this feature over other resource management systems, offers numerous real-word examples and includes step-by-step workshops and exercise solutions that demonstrate the use of this feature. Yet another related database feature that is often underutilized is that of the Oracle Database Scheduler. This training guide book shows how this scheduler compares with other scheduling systems, including the Oracle Enterprise Manager 12c Cloud Control job system. We briefly cover the basic features of the Scheduler that are largely self-evident, but the remainder of our material explores advanced capabilities including integration with the Oracle Database Resource Manager, building sophisticated scheduling systems using job classes, windows and other object components, and employing a file watcher that is especially useful in a data warehouse environment. Perhaps most importantly, we will discuss how proliferating systems and databases resulting from machine virtualization and pluggable databases can be effectively managed using a centralized database Scheduler.
3 days
Contact us for pricing
Contact us for dates
Contact us for dates

Prerequisites

Oracle Database 12c: SQL Fundamentals (Levels I & II)
Oracle Database 12c: Install & Upgrade Workshop
Oracle Database 12c: Architecture & Internals
Oracle Database 12c: Administration Workshop

Managing Resources

About Resource Management
The Database Resource Manager
Resource Manager Architecture

Using Oracle Database Resource Manager

Resource Manager Privileges
Consumer Groups
GRANT_SWITCH_CONSUMER_GROUP()
Resource Plans
Resource Plan Directives
Programmatic Plans & Directives
UTILIZATION_LIMIT Example
UPDATE_PLAN_DIRECTIVE() Example
Resource SUBPLANS
Automatic & Adaptive Mapping
DBMS_APPLICATION_INFO() Attributes
Activating Resource Plans
Monitoring Resource Allocation
Explicit Consumer Group Switching
Instance Caging

Automating Tasks With The Database Scheduler (Basic)

About Scheduling Systems
The Oracle Database Scheduler
Database Scheduler Framework
Programs
Schedules
Jobs
CREATE_JOB() Primary Attributes
SET_ATTRIBUTE() & Secondary Attributes
JOB_STYLE Attribute & Lightweight Job Example
Job & Instance Log Management

Automating Tasks With The Database Scheduler (Advanced)

Job Classes
Windows & Window Groups
Chains
Event-Based Vs. Time-Based Jobs
Automated Maintenance Tasks

Centralized Administration Using The Database Scheduler

Centralized Scheduler Architecture
Central Database Setup
Remote Host Setup
Defining Remote Jobs
Submitting Remote Jobs

Database Scheduler File Watchers & E-­‐Mail Notification

Email Notification
File Watchers