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 188.8.131.52.0 and later
Information in this document applies to any platform.
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
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