The Consumer Groups allow defining properties on a role basis.
They allow fine-grained control of the resource-utilization among users and roles.
This new feature allows specifying idle session timeout within the consumer group.
Long-running open sessions could impact other sessions by holding unnecessary object locks or occupying an active slot.
In the past, the idle session timeout could only be implemented in a watchdog script.
This new feature allows better session management control by killing the session if the specified idle timeout is reached.
The idle timeout is implemented into consumer groups (IDLE_TIMEOUT attribute) .
- Defined as DECIMAL(6,0) for values in the interval <1 , 999999>, in seconds or 0 representing UNLIMITED
- Consumer group attribute value can be set independent of system and session parameters.
- Default value is 86400 seconds (24h)
- Minimum value between session parameter IDLE_TIMEOUT and the user consumer group IDLE_TIMEOUT is considered, to kill the session if this value is reached.
Session and system parameter
This feature is also integrated into new system and session parameters: IDLE_TIMEOUT, which allows fine-grained user control over their own sessions.