Oracle Database 12c: Resource Manager & Scheduler

PT9686
Training Summary
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.
Prerequisites
Oracle Database 12c: SQL Fundamentals (Levels I & II)Oracle Database 12c: Install & Upgrade WorkshopOracle Database 12c: Architecture & InternalsOracle Database 12c: Administration WorkshopOracle Enterprise Manager 12c Cloud Control: Install & Upgrade Workshop (Optional)
Duration
3 Days/Lecture & Lab
Audience
Database administratorsWeb server administratorsSystem administratorsImplementation specialistsData center support engineersSenior application designers and developers
Course Topics
  • Managing resources
  • Using oracle database resource manager
  • Automating tasks with the database scheduler (Basic)
  • Automating tasks with the database scheduler (Advanced)
  • Centralized administration using the database scheduler
  • Database scheduler file watchers & e-mail notification

Related Scheduled Courses