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

Get Mastering Oracle Scheduler in Oracle 11g Databases 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.