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

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