ITPub博客

首页 > 数据库 > Oracle > Oracle OCP IZ0-053 Q449(Scheduler Window&Resource Plan&Schedule Object)

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

原创 Oracle 作者:abstractcyj 时间:2016-03-23 15:48:53 0 删除 编辑
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博客 ” ,链接:https://blog.itpub.net/8520577/viewspace-2062592/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
曾从事java方向开发多年。近年已经转入数据库方向。主要擅长SQL优化,Oracle数据库问题诊断,Oracle备份与恢复等。服务于医药物流,医院等行业

注册时间:2010-01-26

  • 博文量
    602
  • 访问量
    1091629