Chapter 8. The Scheduler in Real Life
In this chapter, we will see how we can incorporate Oracle Scheduler into real-life scenarios and solve various problems in a variety of ways. The scenarios themselves are not really important, but they are real enough to show the power of Oracle Scheduler.
One of the first things to consider when thinking about what to schedule in the Scheduler database is the statistics collection. This is the collection of the optimizer statistics in the database. The challenge here is to have the statistics run whenever they are needed, without slowing down the business application that is supposed to run on the database.
Another thing to consider is running the backups. For the backups, we can use the remote external job agent. Here, we can use the Scheduler Agent and see how to use the Scheduler events to react on the results of a job. This can be seen as an advanced form of chaining where we do not build a chain as an object definition, but as a chain defined by...
