多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

From the V$SESSION_LONGOPS view, you find that some of the database users have long/x7frunning 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
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题