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

12.8. Using Scheduler Windows

In Chapter 11, "Managing Resources," you learned to create and manage resource plans to allocate system resources. Scheduler windows allow you to change the active resource plan based on defined schedules. In general, resource plans tend to be created with specific time windows in mind. For instance, assume that your system performs heavy transaction processing between the hours of 8:00 A.M. and 5:00 P.M. but runs mostly batch processing and reports after hours. It would make sense to create a separate resource plan to govern resource allocation for each time period. Scheduler windows can then be used to switch automatically between the two.

Unlike most of the other Scheduler objects that you've seen so far, windows ...