Re: Is enq: TX - row lock contention a wait or syscall
Date: Mon, 20 Jan 2020 10:59:16 -0500
Message-ID: <CAJSrDUrXNtzo-KhODjNsMRQpmL05cXBQX+ybvOtuspoftz_qyQ_at_mail.gmail.com>
Thanks Jonathan!
Andy - I just wanted to simplify my understanding , academic interest only.
Word 'wait' causes lot of confusion and is not that technically specific ,
so calling it syscall certainly helps :)
Rgds,
Kunwar
On Mon, Jan 20, 2020 at 9:44 AM Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> The answer to your question is at the end of the 3rd paragraph of the blog
> note:
>
> "The event called enqueue: that's a semtimedop call."
>
> Many years ago there was just one event relating to enqueues, and it was
> called "enqueue". Now there are several hundred very specific "enqueue
> waits", of which "enq: TX - row lock contention". So yes, it's a syscall,
> but the full text of the name also gives some background to what prompted
> the syscall.
>
> Regards
> Jonathan Lewis
>
>
>
> ________________________________________
> From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on
> behalf of kunwar singh <krishsingh.111_at_gmail.com>
> Sent: 20 January 2020 14:29
> To: ORACLE-L
> Subject: Is enq: TX - row lock contention a wait or syscall
>
> 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
>
>
>
-- Cheers, Kunwar -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 20 2020 - 16:59:16 CET