196: From the V$SESSION_LONGOPS view, you find that some of the database
users have longrunning queries and are consuming a lot of CPU time. This
causes problems for you when you try to log on as the system user and
perform. small maintenance tasks. You would like to ensure that users SYS
and SYSTEM get priority over all other users. Which method would you use
to achieve this objective?
A.create a plan directive in the SYS_GROUP
B.create the pending area for the consumer group
C.activate the provided SYSTEM_PLAN in Resource Manager
D.set the TIMED_STATISTICS parameter to TRUE in the parameter file
E.set the execution time limit for all users, except SYS and SYSTEM, in
their profiles
Answer: C
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-718267/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
