Advanced Performance Tuning Guide

Advanced Performance Tuning Guide

Database Repository

Database Repository

To improve the database repository performance, consider the following recommendations:
  • Increase the number of concurrent sessions that the database repository can run.
    Only the database administrator can perform this action. For more information, consult your database administrator.
  • For Oracle servers, increase the size and the number of instances of the redo log. Each time the log file reaches the maximum size, the database creates a new log file. Increase the log file size to reduce the number of log files that the database creates during run time. Increasing the number of instances of the log file enables load balancing and increases the availability of the log files. The benchmark tests that are described in this document used three instances of the redo log with a file size of 2 GB for each instance .
  • When the number of events in the event table exceeds three million, archive the events by using Data Archive. Otherwise, the
    B2B Data Exchange
    console can run slower or the scheduled jobs can hang. For more information about how to archive the events, see the
    B2B Data Exchange
    Administrator Guide
    .

0 COMMENTS

We’d like to hear from you!