unfortunately you did not mention the Oracle version but there is no need to
reproduce it if you are on Oracle 12c (and got no additional EE options).
You can use the Events++ "wait_event" and create a system state dump if you
wait longer than <X> microseconds on wait event "enq: IV - contention", e.g.
something like that.
SQL> alter system set events 'wait_event["enq: IV - contention"]
The dump will be created after you have waited but you still have some history
in a system state dump.
Independent Oracle performance consultant and researcher
kunwar singh <krishsingh.111@xxxxxxxxx> hat am 11. Mai 2019 um 16:03--
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