Optimizing database performance

This procedure describes how to optimize the Control-M/EM and Control-M/Server databases.You might need to perform this procedure if your databases have a high transaction rate and high job count.

To optimize your database:

1. Verify that the Oracle or PostgreSQL database is installed on a dedicated computer that does not have the UNIX SWAP file.
2. Assign the Redo Log, WAL, and Transaction logs to a separate disk drive.
3. Verify that the Redo Log, WAL, and Transactions log file is not using a RAID-5 disk (No RAID. RAID 0, RAID 0+1, RAID 10 are OK).
4. Assign the Rollback tablespace Log to a separate disk drive.
5. Verify that the Rollback tablespace file is not using a RAID-5 disk (No RAID. RAID 0, RAID 0+1, or RAID 10 are OK).
6. Assign the Control Files Log to a separate disk drive.
7. Verify that the Control Files are not using a RAID-5 disk (No RAID. RAID 0, RAID 0+1, or RAID 10 are OK).