Resource Manager and Scheduler

Oracle Database 10g enables enterprise-level databases to perform efficiently via a variety of methods. Two of those involve both scheduling the resource usage via a database scheduler and controlling usage via a database resource manager. This requires the use of the Oracle-supplied DBMS_SCHEDULER, DBMS_RESOURCE_MANAGER, and DBMS_RESOURCE_MANAGER_PRIVS built-in PL/SQL packages. We will deal with them briefly here.

Note that both these tasks can be performed using the OEM Database Control screens.

Job Management Using the Scheduler

Jobs and programs that execute in the database can be scheduled via a variety of means. Traditionally, these were scheduled using operating-system utilities such as cron in UNIX/Linux ...

Get Oracle® Database 10g Insider Solutions now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.