Connection pooling (Doc ID 528873.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel System Software - Version: 7.5.3.10 [16198] and later   [Release: V7 and later ]
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 7.5.3.10 [16198]
Database: Oracle 9.2.0.5
Application Server OS: Sun Solaris 8
Database Server OS: Sun Solaris 8

This document was previously published as Siebel SR 38-2649674041.

Goal


We are enabling the Connection Pooling to facilitate more users community accessing our system.

 Q1. If we have connection pooling enabled then how many users are connected to a particular database session
Q2. If we kill the long running query will it impact any other user sharing the connection. If yes then what is solution/work around.(connection pooling is enabled)

Q3. If the Session is killed what is the impact of the 2 users sharing the session.

Q4. If a Db session is running how do we know how many users are connected.



Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms