My Oracle Support Banner

Running Out of Database Connections Available from the Pool (Doc ID 1404663.1)

Last updated on DECEMBER 30, 2021

Applies to:

Oracle WebCenter Content - Version 11.1.1.4.0 and later
Information in this document applies to any platform.

Goal

If long running queries are occurring that consume the allotted connections in the database pool, some measures can be taken in WebCenter Content to keep threads from becoming in a STUCK status.

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
 Defragment the fulltext index
 Increase MaxSearchConnections
 Set a Statement Timeout in the CSDS Data Source in WebLogic Admin Server
 Set IdcServerThreadQueryTimeout in WCC config.cfg file
References


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