Let’s go over Oracle VIP.
At times, in the cluster configuration, SharePlex uses Oracle VIP instead of host clustering VIP.
SP_SYS_HOST_NAME
ASM Connection
Deadlock due to HCC(Exadata)
Block level deaklock issue could happen when HCC is enabled.
Hybrid Columnar Compression(HCC) is the way Exadata compresses the data. HCC utilizes a combination of both row and columnar methods for storing data.
A logical construct, called the Compression Unit (CU), is used to store a set of compressed data.
Deadlock due to ITL
Apparently, a deadlock issue is related to resource contention between 2 actions.
Then, what could be the resources in this case?
At first, you can think of the real row-level contention.
Normally, it results from the abnormal Application design or replication product defects.
At this time, I would like to focus on other resource-related deadlock issues(block-level contention).
First thing in the morning
“First thing in the morning, work on your most important task. Don’t do anything else until this is done.”
What is your first thing in the morning?