O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required