單項(xiàng)選擇題

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

你可能感興趣的試題

單項(xiàng)選擇題

Your database is running in the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（）

A.modify the HASH_AREA_SIZE initialization parameter
B.modify the PGA_AGGREGATE_TARGET initialization parameter
C.modify the WORK_AREASIZE_POLICY initialization parameter
D.increase the value of the SGA_TARGET initialization parameter
E.increase the value of the SGA_MAX_SIZE initialization parameter
F.increase the value of the SORT_AREA_SIZE initialization parameter

單項(xiàng)選擇題

In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files.
Which option would you use to migrate the database files from a nonASM instance to an ASM instance？（）

A.Oracle Migration Assistant
B.Recovery Manager （RMAN）
C.Oracle Data Pump Export and Import
D.conventional Oracle Export and Import
E.operating system utilities to copy the files to the ASM instance

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

你可能感興趣的試題

Your database is running in the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（）

In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non­ASM instance to an ASM instance？（）

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files.
Which option would you use to migrate the database files from a nonASM instance to an ASM instance？（）