Performance Tuning Guidelines for Infrastructure

Database

Database tuning is a highly specialized area, and it is recommended that DBA expertise be available when running performance tests and tuning the system.

Consider using Oracle Enterprise Manager to help tune the database http://www.oracle.com/technetwork/oem/db-mgmt/db-mgmt-093445.html?ssSourceSiteId=ocomen. Learning how to create Oracle ADDM reports is a good idea and a good option if OEM is not available.

Adding appropriate indexes (as recommended by these tools) can help improve performance.

Enterprise Message Service

TIBCO EMS is used as a messaging bus to integrate TIBCO Fulfillment Order Management with the external systems, as well for the integration between the various TIBCO Fulfillment Order Management components. Most of the tuning parameters, such as max connections, various memory settings, and so on, of TIBCO EMS are available in the tibemsd.conf file present in the configuration directory of EMS. Refer to the TIBCO EMS documentation for tuning details.