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

Hello Kunwar,
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"] {wait:minwait=500000} systemstate()';

The dump will be created after you have waited but you still have some history in a system state dump.

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK

> kunwar singh <krishsingh.111_at_gmail.com> hat am 11. Mai 2019 um 16:03 geschrieben:
>
> Hi Listers,
>  
> 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