Our DBA recommended enabling RCSI (Read Committed Snapshot Isolation) setting on the CA_UIM database to avoid frequent blockings. Is this setting supported?
Release: 20.4
Yes, UIM DBA confirmed RCSI may help the database performance but your DBA should read, review and consider all the advantages/disadvantages.
Read Committed Snapshot Isolation (RCSI)