You want to create a consumer group, GROUP1, and you execute the following command in the commandline 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: ORA29371: pending area is not active ORA06512: at "SYS.DBMS_RMIN", line 115 ORA06512: at "SYS.DBMS_RESOURCE_MANAGER", line 108 ORA06512: at line 1 What action would you take to overcome this error?()
- Acreate the Pending Area before creating the consumer group
- Bactivate the Pending Area before creating the consumer group
- Cincrease the size of the large pool to accommodate the Pending Area
- Dincrease the size of the shared pool to accommodate the Pending Area
- Eincrease the size of the database buffer cache to accommodate the Pending Area