單項(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

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

你可能感興趣的試題

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？（）

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？（）