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

Last updated on NOVEMBER 08, 2024

Applies to:

Oracle WebCenter Content for OCI - Version 12.2.1.4.0_24.2 and later
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.

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

Applies to:

Goal

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!