How to simulate/generate the wait event "enq: IV - contention"

From: kunwar singh <krishsingh.111_at_gmail.com>
Date: Sat, 11 May 2019 10:03:36 -0400
Message-ID: <CAJSrDUp86UHs-x+pDEiT0puA5n7NowNRJb8czcvShK1=GUuF5Q_at_mail.gmail.com>

I have a strange issue in one of accounts that my company supports. This wait coming daily at sporadically different times. It lasts only for few seconds, but it creates havoc for application job at that moment. How do we troubleshoot this apart from going to MOS. I would like to go deep into it , so is there a way/testcase i can reproduce the this wait event and then scan though all data dictionary /10046/other dumps in order to find the root cause and fix for it. Once i am able to reproduce this wait, IMO , it will get easier to troubleshoot it.

-- 
Cheers,
Kunwar

--
http://www.freelists.org/webpage/oracle-l

Received on Sat May 11 2019 - 16:03:36 CEST

This message: [ Message body ]
Next message: Andy Sayer: "Re: How to simulate/generate the wait event "enq: IV - contention""
Previous message: niall.litchfield_at_gmail.com: "Re: SQL Developer connection issues"
Next in thread: Andy Sayer: "Re: How to simulate/generate the wait event "enq: IV - contention""
Reply: Andy Sayer: "Re: How to simulate/generate the wait event "enq: IV - contention""
Reply: Stefan Koehler: "Re: How to simulate/generate the wait event "enq: IV - contention""

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message