Questions related to Resource manager
I have 2 queries.
Question 1:
I am testing Resource manager for first time.
I created a plan, group and mapping through 'MODULE_NAME' attribute.
I set few directives. Now this question is related to directive ACTIVE_SESS_POOL_P1. I set this directive parameter to 2 expecting it will not allow more than 2 active sessions for this consumer group.
When I test, I connected and used dbms_application_info.set_module to set the module name and confirmed that consumer group is set correctly through RESOURCE_CONSUMER_GROUP in v$session.
I connected 3 or 4 sessions and it allowed. OK. They are inactive sessions.
I am testing Resource manager for first time.
I created a plan, group and mapping through 'MODULE_NAME' attribute.
I set few directives. Now this question is related to directive ACTIVE_SESS_POOL_P1. I set this directive parameter to 2 expecting it will not allow more than 2 active sessions for this consumer group.
When I test, I connected and used dbms_application_info.set_module to set the module name and confirmed that consumer group is set correctly through RESOURCE_CONSUMER_GROUP in v$session.
I connected 3 or 4 sessions and it allowed. OK. They are inactive sessions.
0