Oracle
1Z0-043 · Question #197
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'…
The correct answer is B. create the Pending Area before creating the consumer group. See the full explanation below for the reasoning.
Question
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?
Options
- Aactivate the Pending Area before creating the consumer group
- Bcreate the Pending Area before creating the consumer group
- Cincrease the size of the database buffer cache to accommodate the Pending Area
- Dincrease the size of the shared pool to accommodate the Pending Area
- Eincrease the size of the large pool to accommodate the Pending Area
How the community answered
(21 responses)- A5% (1)
- B76% (16)
- D14% (3)
- E5% (1)
Community Discussion
No community discussion yet for this question.