My Oracle Support Banner

Connection pooling (Doc ID 528873.1)

Last updated on DECEMBER 20, 2018

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Goal
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.