Oracle Database 12c: The Scheduler

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.