單項選擇題

You want to create a consumer group, GROUP1, and you execute the following command in the command-line interface: 
SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP =>’group1’, 
COMMENT => ’New Group’); 
This command errors out displaying the following message: 
ERROR at line 1: 
ORA-29371: pending area is not active 
ORA-06512: at "SYS.DBMS_RMIN", line 115 
ORA-06512: at "SYS.DBMS_RESOURCE_MANAGER", line 108 
ORA-06512: at line 1 
What action would you take to overcome this error?()

A. activate the Pending Area before creating the consumer group
B. create the Pending Area before creating the consumer group
C. increase the size of the database buffer cache to accommodate the Pending Area
D. increase the size of the shared pool to accommodate the Pending Area
E. increase the size of the large pool to accommodate the Pending Area

題目列表

你可能感興趣的試題

微信掃碼免費搜題