Deployment of Human Tasks using ANT results in Excessive Database Connections to the MDS Schema
Last updated on OCTOBER 01, 2014
Applies to:Oracle SOA Suite - Version 22.214.171.124.0 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