Deployment of Human Tasks using ANT results in Excessive Database Connections to the MDS Schema (Doc ID 1931173.1)

Last updated on OCTOBER 01, 2014

Applies to:

Oracle SOA Suite - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

Human Workflow application, deployed through Ant, is creating a growing number of connections to the MDS schema over time resulting in resource exhaustion.  

In the WLS Admin Console the maximum number of physical connections that the mds-soa data source connection pool can contain is 50. Nevertheless, when the following query is performed "select * from v$session where schemaname like '%MDS%'; ", the result is 157 connections to MDS schema all with status inactive. The connection type is DEDICATED.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms