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

From: kunwar singh <krishsingh.111_at_gmail.com>
Date: Tue, 21 Jan 2020 07:28:59 -0500
Message-ID: <CAJSrDUqp3OWAScRHVr6-csV21RGBgh86HRbaix76Vm_2L9yjKQ_at_mail.gmail.com>



Thanks Stefan. Very helpful!

On Tue, Jan 21, 2020 at 2:16 AM Stefan Koehler <contact_at_soocs.de> wrote:

> 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
>

-- 
Cheers,
Kunwar

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 21 2020 - 13:28:59 CET

Original text of this message