ITPub博客

首页 > 数据库 > Oracle > Oracle OCP 1Z0 053 Q637(Scheduler Window)

Oracle OCP 1Z0 053 Q637(Scheduler Window)

原创 Oracle 作者:abstractcyj 时间:2016-04-04 15:52:48 0 删除 编辑
637.Which three statements are true about windows? (Choose three.)
A. Only one window can be open at any given time
B. Consumer groups are associated with windows
C. Windows work with job classes to control resource allocation
D. The database service name must be provided during windows creation
E. Windows can automatically start job or change resource allocation among jobs for various time
periods.
Answer: ACE

B:Consumer groups应当是与resource plan关联

参考:http://docs.oracle.com/cd/E11882_01/server.112/e25494/schedover.htm#ADMIN12366
http://blog.csdn.net/rlhua/article/details/19173741
Because only one window can be active at one time
, the following rules are used to determine which window is active when windows overlap:

什么是window:
https://docs.oracle.com/cd/B19306_01/server.102/b14231/scheduse.htm#i1010604

Windows provide a way to automatically activate different resource plans at different times. Running jobs can then see a change in the resources that are allocated to them when there is a change in resource plan.

The key attributes of a window are its:

  • Schedule

    This controls when the window is in effect.

  • Duration

    This controls how long the window is open.

  • Resource plan

    This names the resource plan that activates when the window opens.

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/8520577/viewspace-2075033/ ,如需转载,请注明出处,否则将追究法律责任。

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

注册时间:2010-01-26

  • 博文量
    602
  • 访问量
    1091620