Re: Is enq: TX - row lock contention a wait or syscall
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 20 Jan 2020 14:43:44 +0000
Message-ID: <LNXP265MB1562562F2925AD32A875B09EA5320_at_LNXP265MB1562.GBRP265.PROD.OUTLOOK.COM>
Date: Mon, 20 Jan 2020 14:43:44 +0000
Message-ID: <LNXP265MB1562562F2925AD32A875B09EA5320_at_LNXP265MB1562.GBRP265.PROD.OUTLOOK.COM>
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 Received on Mon Jan 20 2020 - 15:43:44 CET