My Oracle Support Banner

When activating server-side connection pooling, is it possible to force all clients to use the connection pool? (Doc ID 3073311.1)

Last updated on FEBRUARY 25, 2025

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Information in this document applies to any platform.

Goal

When activating server-side connection pooling (DRCP), is it possible to force all clients to use the connection pool?
I have activated server-side connection pooling (DRCP), so all clients can connect via @:1521/:POOLED. However, I want all connections to be pooled, regardless of whether the client specifies :POOLED or not.
I don't want to write a LOGON trigger to raise an error if the client does not use :POOLED, and I would like the connection pooling to be transparent to the client.

Is there a way to achieve this?

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


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