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 AUTOMIC WORKLOAD AUTOMATION CA Automic One Automation CA Automic Operations Manager CA Automic Oracle

Issue/Introduction

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

Environment

Release : 12.2

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 and monitor from there - if rollback space is sufficient and there are too many logswitches occurring, increase CommitCntDel.