|
|
|
|
|
|
Oracle Training 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 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.
Oracle Training Audience
The primary target audiences for this course are:
- Database administrators
- Web server administrators
- System administrators
- Implementation specialists
- Data center support engineers
- Senior application designers and developers
Oracle Training Certification
This textbook considers subjects applicable to certification training as an Oracle Database 12c
Administrator Certified Associate (OCA) for "Exam: 1Z0-062: Oracle Database 12c: Installation And
Administration"
Oracle Training Prerequisites
Specific course prerequisites for this course are these titles:
- ORACLE DATABASE 12C: SQL FUNDAMENTALS (LEVELS I & II)
- ORACLE DATABASE 12C: INSTALL & UPGRADE WORKSHOP
- ORACLE DATABASE 12C: ARCHITECTURE & INTERNALS
- ORACLE DATABASE 12C: ADMINISTRATION WORKSHOP
An additional optional but recommended prerequisite is ORACLE ENTERPRISE MANAGER 12C CLOUD
CONTROL: INSTALL & UPGRADE WORKSHOP.
Training Suggestions
The next certification training series that follows this one is for an Oracle Database 12c Administrator
Certified Professional (OCP). These training modules are included in that certification series:
- ORACLE DATABASE 12C: MANAGE THE MULTITENANT ARCHITECTURE
- ORACLE DATABASE 12C: ADVANCED ADMINISTRATION & ASM
- ORACLE DATABASE 12C: BACKUP & RECOVERY WORKSHOP
Oracle Training Course duration
3 Days
Oracle Training Course outline
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
|
|
|
|
|
