Redo Logs

Since ActiveMatrix BPM makes heavy use of transactions, the configuration and location of the Oracle redo logs are critical. These files hold information about changes to the database.

For more information about Oracle redo logs, see http://docs.oracle.com/cd/B28359_01/server.111/b28310/onlineredo001.htm#ADMIN11302

The location, size, and number of redo log files can impact ActiveMatrix BPM performance. If Oracle reports that there is excessive log switching, increase the size of the redo log files.

To get an Oracle report for a test, run the Automatic Database Diagnostic Monitor (ADDM) report for a given period based on Oracle’s snapshots. For more information on the ADDM reporting, see http://www.oracle-base.com/articles/10g/automatic-database-diagnostic-monitor-10g.php. This can be used to pick up heavy SQL being performed that might require a different execution plan or changes to indexes on tables.

Copyright © Cloud Software Group, Inc. All rights reserved.