What is the difference between Database Resource Managers DEFAULT_CONSUMER_GROUP and OTHER_GROUPS?
If a user is not assigned to a user group, he/she is a member of DEFAULT_CONSUMER_GROUP. One reason for this consumer group is administrative time savings. For example, 25% of all users might be explicitly assigned to OLTP, with another 5% specified as members of the DSS group. The remaining 70% would already be members of the DEFAULT_CONSUMER_GROUP. If the remaining 70% should be prioritized similarly, and therefore managed as a single group, no more work is required to assign users to groups. Because of DEFAULT_CONSUMER_GROUP, everyone belongs to a group (either explicitly-assigned, or DEFAULT_CONSUMER_GROUP). Like all consumer groups, specifying the DEFAULT_CONSUMER_GROUP in the active plan is optional. OTHER_GROUPS is not a group in that users can not be assigned to it. Users map to user groups one-to-one, and every user belongs to a group (DEFAULT or explicitly assigned, see above). When a group is not included in the active plan, its members default to the resources assigned to O
