Database Resource Plan not working...
603348Jun 9 2009 — edited Jun 9 2009DbVersion: 10.2.0.4
For some reason my resource plan is not taking effect. I've created 4 resource consumer groups. I've created a plan utilizing these consumer groups. The plan is enabled and is the top plan. The resource_manager_plan parameter is set to: FORCE:MYPLAN and I've also tried setting it to "MYPLAN" only.
The Consumer Group mappings have been set at the service level. So depending on the database service you're connecting via you should be using a particular consumer_group.
The problem is that everyone that connects regardless of what service they are using is routed to use the "OTHER_GROUPS" group (except for the sys and system users).
I find this information with the following query:"
SELECT USERNAME,SERVICE_NAME,RESOURCE_CONSUMER_GROUP FROM GV$SESSION;
What am I missing? Do I need to bounce the database or something in order for a resource plan to take effect?