Performance drop when inserting large Payload using DBAdapter

In BPEL and OSB when  inserting a lot of data (big payload messages) into the database by using jca db adapter.
We noticed performance would drop hugely when the db adapter needed to insert large payloads (CLOBS) and when the stream of messages on these services would continue even more performance would dramastically go down on the system.

After disabling “wrap data types” on the datasource in Weblogic we had a pretty good performance win on processing big clob messages into the database.

To disable wrapping of data type objects do the next :

·       Login the Weblogic Console

·       Click yourdomain > Services > Data Sources > your_datasource > Connection Pool > Advanced > disable Wrap Data Types