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