Filter
Top Products
The Sterling B2B Integrator system administrator must work with the DBA to
identify the indexes that must be rebuilt. You must always rebuild indexes at
schema level.
Sterling B2B Integrator is a high-volume OLTP application, and rarely, there might
be times when you might need to shrink the tables or rebuild indexes. Oracle
documentation provides details about the following tasks:
v Shrinking database segments online
– http://docs.oracle.com/cd/B28359_01/server.111/b28310/
schema003.htm#ADMIN10161 (Oracle Database 11g Release 1)
– http://docs.oracle.com/cd/E18283_01/server.112/e17120/
schema003.htm#ADMIN10161 (Oracle Database 11g Release 2)
– http://docs.oracle.com/database/121/ADMIN/schema.htm#CBBBIADA
(Oracle Database 12c Release 1)
v Rebuilding an existing index
– http://docs.oracle.com/cd/B28359_01/server.111/b28310/
indexes004.htm#ADMIN11734 (Oracle Database 11g Release 1)
– http://docs.oracle.com/cd/E18283_01/server.112/e17120/
indexes004.htm#insertedID2 (Oracle Database 11g Release 2)
– http://docs.oracle.com/database/121/ADMIN/indexes.htm#i1006864 (Oracle
Database 12c Release 1)
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,. 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.
Using Oracle Real Application Clusters (RAC) for High
Availability
Oracle Real Application Clusters (RAC) ensures high availability by supporting the
deployment of a database across multiple machines, thereby reducing the
downtime due to hardware failures or outages, planned or unexpected.
The following diagram shows how all transactions should be sent to one Oracle
RAC node at a time. If that database node goes down, all Sterling B2B Integrator
nodes reconnect to the second available database node. This scenario requires that
load balancing is turned off, and provides better overall system performance.
32 Sterling B2B Integrator: Performance Management