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