I'm working on a 12C Rel. 1 database. the tables for this database are create with compression for query low.
We noticed some deadlocks on these tables as they are updated often. After investigating I see that this can happen with HCC and tables that are updated and that I have 2 solutions:
1) Take the tables and their partitions out compression for query low and use compress for oltp.
2) Keep using HCC with compression for query low and enable row level locking.
Solution No.2 looks better but I found in a non-oracle document that when a table is updated then HCC compression becomes very bad to a point that very little data are compressed and it is better to use compress for oltp. In the Oracle documentation I didn't find this.
Any suggestion as to which of the 2 solutions is best would be appreciated.
Thank you