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


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.


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