What is an active session pool?
What is an active session pool?
Rating:
An active session pool is a feature that allows a user to control the maximum number of active sessions permissible within a resource consumer group. As more active sessions are created within a resource consumer group, the resource consumption increases accordingly. This may lead to a situation where a single resource consumer group is engaging the entire available resources, whereas other groups are starving. To avoid this situation, the active session pool queues the active sessions that are created beyond the permissible limit, without actually executing them. A queued active session is executed only after an existing active session ends. The active session pool follows the first-in-first-out queuing principle. There is only one active session pool for each resource consumer group.
Rating:
Other articles
- What is data dictionary?
- What is Program Global Area (PGA)?
- What is a tablespace?
- What is data dictionary cache?
- What is shared pool?