My Oracle Support Banner

OBIEE 12c - Connection Pooling Is Enabled In The RPD DB Connection, But Connection Isn't Reused When Query Sent To Backend DB (Doc ID 2571531.1)

Last updated on MARCH 11, 2020

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

Per Oracle documentation, when "enable connection pool" setting is checked in the RPD,

It will allows a single database connection to remain open for the specified time for use by future query requests.

Connection pooling saves the overhead of opening and closing a new connection for every query

If you don't select this option, each query sent to database opens a new connection

But in 12c, it's still opening multiple sessions when  "enable connection pool" is checked

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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