Wait Event - enq: IV - contention

  • From: Biju Thomas <biju.thomas@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 27 Mar 2018 17:40:46 +0000

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
represent.

Current Wait Event              enq: IV - contention

Current Wait Class               Other

P1                         type|mode 1230372869

P2                         id1 1398361667

P3                         id2 3

Object                   None


They are not OBJECT_IDs.


Version: Oracle database 11.2.0.4

RAC Database, 4 nodes.


Thanks for your help.

Biju Thomas


-- 
Best,
Biju Thomas
www.bijoos.com

Other related posts: