Re: Is enq: TX - row lock contention a wait or syscall
Date: Tue, 21 Jan 2020 08:16:50 +0100 (CET)
Message-ID: <1091708644.126593.1579591010997_at_ox.hosteurope.de>
Hello Kunwar,
On my website you can find a simple example how the locking / synchronization works: http://www.soocs.de/public/research/190513_semaphore_sync.txt
Best Regards
as all others already replied: Yes, the wait event "enq: TX - row lock contention" instruments a wait on syscall semtimedop() in the background.
Independent Oracle performance consultant and researcher
Website: http://www.soocs.de
Twitter: _at_OracleSK
> kunwar singh <krishsingh.111_at_gmail.com> hat am 20. Januar 2020 um 15:29 geschrieben:
>
> Hi Listers,
> I am reading the below blog:
> Â
> http://carymillsap.blogspot.com/2009/02/dang-it-people-theyre-syscalls-not.htmlÂ
> Â
> So i have one basic question. Is  enq: TX - row lock contention also a syscall then or am i simplifying it too much?
>
> --
> Cheers,
> Kunwar
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 21 2020 - 08:16:50 CET