BPEL PM Causing Error Exceeding OPEN_CURSOR Limit On Database

(Doc ID 421289.1)

Last updated on SEPTEMBER 09, 2017

Applies to:

Oracle(R) BPEL Process Manager - Version: 10.1.3.1 to 10.1.3.3 - Release: AS10gR3 to
Information in this document applies to any platform.
***Checked for relevance on 21-Sep-2010***

Symptoms

Application - Oracle SOA Suite 10g Release 3 (10.1.3.1.0)

Issue - If statement caching is enabled for BPEL JDBC connection pool, users may run into an issue where they observe excessive open_cursors on BPEL middleware (dehydration store) database when dehydration is turned ON.

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