Leave a Reply 1

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


Jake from SF

Jake from SF

E is correct, although B is correct too when using CREATE_SIMPLE_PLAN procedure:

http://docs.oracle.com/cd/B19306_01/server.102/b14231/dbrm.htm

Creating a Simple Resource Plan
Each consumer group specified in the plan is allocated its CPU percentage at level 2. Also implicitly included in the plan are SYS_GROUP (a system-defined group that is the initial consumer group for the users SYS and SYSTEM) and OTHER_GROUPS.

For all other resource plans, OTHER_GROUPS needs to be included.