Re: Is enq: TX - row lock contention a wait or syscall

From: Stefan Koehler <contact_at_soocs.de>
Date: Tue, 21 Jan 2020 08:16:50 +0100 (CET)
Message-ID: <1091708644.126593.1579591010997_at_ox.hosteurope.de>


Hello Kunwar,
as all others already replied: Yes, the wait event "enq: TX - row lock contention" instruments a wait on syscall semtimedop() in the background.

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
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 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-l
Received on Tue Jan 21 2020 - 08:16:50 CET

Original text of this message