当前位置:1z0-043题库

问题:

[单选]

From the V$SESSION_LONGOPS view, you find that some of the database users have long-running 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 profile

SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason?() The User Global Area (UGA) is not configured.。 The sessions were started using the login name SYS.。 The sessions are running in the Automatic Shared Memory Management mode.。 The sessions are running in the automatic Program Global Area (PGA) memory management mode.。 国家电网公司对风电场有功功率的基本要求是什么? A customer has two single cluster IBM TS7700 Virtualization Engines at the same site. The customer wants to move one to a remote site and set up a grid configuration with the two clusters. The customer has fibre between the two sites. What is the most important factor to consider when planning the new configuration?() operator training。 cache size of the two clusters。 fibre bandwidth capability between the sites。 number of stacked tape drives attached to each cluster。 You need to design a storage mode for the ProductOrderStatus measure group. What should you do?() Use ROLAP for the Historical partition and MOLAP for the CurrentDay partition.。 Use MOLAP for the Historical partition and ROLAP for the CurrentDay partition.。 Use ROLAP for the Historical partition and Automatic MOLAP for the CurrentDay partition.。 Use HOLAP for the Historical partition and Low-latency MOLAP for the CurrentDay partition.。 Which two activities are NOT supported by the Data Recovery Advisor DRA() Recover from failures in the RAC environment.。 Diagnose and repair a data file corruption online.。 Diagnose and repair a data file corruption offline.。 Diagnose and repair failures on a standby database。

From the V$SESSION_LONGOPS view, you find that some of the database users have long-running 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?()

参考答案:

  参考解析

本题暂无解析

在线 客服