What is the impact of CommitCntDel and CommitCnt is the Automic Client Copy

book

Article ID: 141351

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic Workload Automation - Automation Engine

Issue/Introduction

The documentation states that modification to these may impact performance, but what modifications could be made?

Environment

Release : 12.x

Component : AUTOMATION ENGINE

Resolution

The value for CommitCntDel (and CommitCnt) would need to be decided between the Administrator and the DBA.

This does limit the number of records deleted during a single transaction; having larger values requires larger rollback segments, but needs fewer commits/writes to the redo log (and vice versa).

Please note that CommitCnt is utilized for AH, RH, RT, MELD and CommitCntDel is utilized for all other tables.

As a start, review usage of CommitCnt, set CommitCntDel to the same value and monitor from there - if rollback space is sufficient and there are too many logswitches occurring, increase CommitCntDel.

For example, if enough space is available, a good start would be increasing the value from default 1000 to 5000 for both CommitCnt and CommitCntDel.

This should reduce a lot the time to delete/import several million records.