O'Reilly logo

Mastering Oracle Scheduler in Oracle 11g Databases by Ronald Rood

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

Chapter 9. Other Configurations

I hope that the previous chapters gave enough handles to start working with the Scheduler. I am aware that there is a lot more to tell about the Scheduler, and this chapter will shed light on some other configurations where the Scheduler can be used. This time it is about RAC (Real Application Clusters) and the standby databases.

RAC

When the jobs you are running depend on things other than just the database, it might be interesting to know what these other things are, and where they can be found. There are several ways to control which instance a job is going to run, some of which are:

  • Define instance_id in the job definition

  • Use instance_stickiness in the job definition

  • Define service_name in the job class definition ...

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