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