title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Oracle Database 12c: Resource Manager & Scheduler
Duration
3 Days
Course
DBOR-959
Available Formats
Classroom Training, Online Training
Course Description
Overview
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 course 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 course 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.
Objectives
Audience
- Database administrators
- Web server administrators
- System administrators
- Implementation specialists
- Data center support engineers
- Senior application designers and developers
Prerequisites
- DBOR-950 and DBOR-951 Oracle Database 12c: SQL Fundamentals (Levels I & II)
- DBOR-955 Oracle Database 12c: Install & Upgrade Workshop
- DBOR-956 Oracle Database 12c: Architecture & Internals
- DBOR-957 Oracle Database 12c: Administration Workshop
- DBOR-960 Oracle Enterprise Manager 12c Cloud Control: Install & Upgrade Workshop (recommended)
Topics
- About Resource Management
- The Database Resource Manager
- Resource Manager Architecture
- 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
- 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
- Job Classes
- Windows & Window Groups
- Chains
- Event-Based Vs. Time-Based Jobs
- Automated Maintenance Tasks
- Centralized Scheduler Architecture
- Central Database Setup
- Remote Host Setup
- Defining Remote Jobs
- Submitting Remote Jobs
- Email Notification
- File Watchers
Related Courses
-
Introduction to Oracle Database 12c and SQL
DBOR-950- Duration: 3 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,100.00 USD
-
Oracle Database 12c: SQL II - Intermediate
DBOR-951- Duration: 3 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,100.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
Exam Terms & Conditions
??exam-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.