125. Which statement is true while creating subplans using Resource M
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
D. You can use a resource plan instead of a consumer group to impleme
nt a priority ranking within the plan.
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
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11312660/viewspace-718044/，如需转载，请注明出处，否则将追究法律责任。