OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043

12.10. Summary

In this chapter, you learned about the new Oracle 10g Scheduler. You learned how it resolves issues such as schedule creep that existed in its predecessor, the DBMS_JOB package.

This chapter also explained the new architecture that underlies the Scheduler. You learned how the job table stores all enabled jobs within the database, and you learned how the job coordinator process queries the job table on a regular basis and stores the job information in a memory cache for faster access. When a job is scheduled to run, the job coordinator process is automatically started (if it is not already active). It will pass the job information to a job slave process for execution.

You learned that the job slave process will gather all the metadata ...