ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 043-125

043-125

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-08 10:20:14 0 删除 编辑
125. Which statement is true while creating subplans using Resource M
anager?
A. The subplan must belong to the consumer group, SYS_GROUP.
B. The total CPU usage at any given level must be less than 100%.
C. The subplans can be used to restrict the degree of parallelism for
a user.
D. You can use a resource plan instead of a consumer group to impleme
nt a priority ranking within the plan.
Answer: D
不懂
对应D 的解释
It is very simple to use the Database Resource Manager in an environment
Where each application user logs on to the database using a different
database username. It is also not very difficult to implement it where
applications use generic database login. Since Database Resource Manager
actually controls resource utilization at the session level, it is
possible to prioritize one session over another, even if both the
sessions belong to the same database user. Therefore, it is possible to
switch a session to the desired consumer group because of the user’s
application role, using the DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP
procedure

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

上一篇: 043-124
下一篇: ETL
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    213919