What action would you take to overcome this error?

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?

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Ruth

Ruth

Downlaod neew Madden 17 Coin Glitch and Generator game!
Best Madden NFL 17 Coin Glitc and Generayor for unlimied Cash and Coins!

DOWNLOAD LINK : Madden NFL 17 Coin Glich and Generator