Considerations for Oracle RAC
Suggested settings for working most effectively with Oracle RAC:
- Change the Oracle sequences that are created at installation so that no matter which Oracle RAC instance you connect to, the order is maintained. For example:
ALTER SEQUENCE INMAIL__SEQ ORDER NOCACHE;ALTER SEQUENCE LISTS__SEQ ORDER NOCACHE;
- Change task scheduler settings:
- Incremental update of mailing stats -- every 10 minutes
- Moderate auto-approve -- every 10 minutes
- Check new for doc send -- every 10 minutes
- Remove archives -- every day at 2:10
- Recheck for doc send -- every day at 2:20
- Remove old metric events -- every day at 2:30
- Delete old web access log entries -- every day at 2:50
- Delete done mail -- every day at 3:10
- * all other tasks are disabled.