Trying to troubleshoot a stuck program. The program gets stuck at a
particular wait event 1 out of every 8 runs on an average. When the program
completes, it finishes in few minutes. When it is stuck, the P1, P2 values
are always the same. Can you please tell what the P1, P2, P3 values
Current Wait Event enq: IV - contention
Current Wait Class Other
P1 type|mode 1230372869
P2 id1 1398361667
P3 id2 3
They are not OBJECT_IDs.
Version: Oracle database 126.96.36.199
RAC Database, 4 nodes.
Thanks for your help.