Wait Event - enq: IV - contention
From: Biju Thomas <biju.thomas_at_gmail.com>
Date: Tue, 27 Mar 2018 17:40:46 +0000
Message-ID: <CAF9tyKqHhVCpx=ip1O=VPPdiSBDR2soZzRhJHGHJuXBvOkt7rw_at_mail.gmail.com>
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.
Date: Tue, 27 Mar 2018 17:40:46 +0000
Message-ID: <CAF9tyKqHhVCpx=ip1O=VPPdiSBDR2soZzRhJHGHJuXBvOkt7rw_at_mail.gmail.com>
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
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 27 2018 - 19:40:46 CEST