Enable BLOB Caching

By default, Oracle database configures itself with the BLOB caching disabled when you choose Oracle as your database during Sterling B2B Integrator installation. You can significantly improve performance by enabling the cache on the BLOB data object.

To enable BLOB caching, run the following commands while connected to the database:

ALTER TABLE DATA_TABLE MODIFY LOB (DATA_OBJECT) (CACHE)

ALTER TABLE TRANS_DATA MODIFY LOB (DATA_OBJECT) (CACHE)

For regular tuning and best practices pertaining to Oracle, refer to the corresponding Oracle documentation.