Oracle DBA - WEEKENDPLAN resource plan

Q.  Using oracle scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00 p.m. every friday. You want both the jobs to use a single resource plan, weekend_plan. Which task must have already been performed to enable you to achieve this objective?
- Published on 30 Jul 15

a. A window must have been created with the WEEKEND_PLAN resource plan
b. A program must have been created with the WEEKEND_PLAN resource plan
c. A job class must have been created with the WEEKEND_PLAN resource plan
d. A window group must have been created with the WEEKEND_PLAN resource plan

ANSWER: A window must have been created with the WEEKEND_PLAN resource plan

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 25 Aug 15
    -A window must have been created with the WEEKEND_PLAN resource plan.
    -Window - You create windows to change resource allocation among the jobs during various time periods of the day, week, and so on.
    -A window is represented by an interval of time with a well-defined beginning and end, such as "from 12am-6am".
    -Windows work with job classes to control resource allocation.
    -Each window specifies the resource plan to activate when the window opens (becomes active), and each job class specifies a resource consumer group or specifies a database service, which can map to a consumer group.
    -A job that runs within a window therefore has resources allocated to it according to the consumer group of its job class and the resource plan of the window.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲