Oracle OCP IZ0-053 Q449(Scheduler Window&Resource Plan&Schedule Object)

abstractcyj發表於2016-03-23
449.Which of the following objects can be directly referenced by a window object? (Choose all that apply.)
A. Schedule object
B. Program object
C. Job object
D. Resource plan
E. Resource consumer group
Answer: AD

Window是Oracle資料庫用來管理schedule jobs的一個工具,可以通過resource plan控制分配給作業的資源的多少

參考:
Windows define the times when resource plans are active.  Since job classes point to resource consumer groups, and therefore resource plans, this mechanism allows control over the resources allocated to job classes and their associated jobs during specific time periods.  A window can be assigned to the schedule_name parameter of a job instead of a schedule object.

http://www.dba-oracle.com/job_scheduling/windows.htm

https://docs.oracle.com/cd/B28359_01/server.111/b28310/schedadmin006.htm

可以從建立window的過程引數看出,window是可以引用resource plna與schedule object的
BEGIN
  dbms_scheduler.create_window(window_name     =>,
                               resource_plan   =>,
                               schedule_name   =>,
                               duration        =>,
                               window_priority =>,
                               comments        =>);
END;

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2062592/,如需轉載,請註明出處,否則將追究法律責任。

相關文章