KPothula
KPothula

Reputation: 257

Oracle Fusion Middleware Datasource getting suspended frequently

We are using Oracle SOA Suite 11g and the Datasource that is used by the BPEL server goes to suspended mode frequently.

As the SOA datasource goes suspended, all the managed servers that use this datasource get too busy trying to connect to the DB and cause high CPU and hence making the server unresponsive.

Anyone experienced this issue and have a solution? We have already posted this in Oracle forums and created a support ticket but any help is appreciated.

Upvotes: 1

Views: 2579

Answers (2)

KPothula
KPothula

Reputation: 257

we've been using the modified setting for a while and we dont see the issue anymore. Looks like changing the SyncMaxTimeout from default 45 to 240 worked.

Upvotes: 1

Musannif Zahir
Musannif Zahir

Reputation: 3029

There are multiple scenarios that could cause this to happen. A good starting point will be to enable the JDBC debug logs to see what's causing the suspension.

Upvotes: 0

Related Questions