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

  • From: Stefan Koehler <contact@xxxxxxxx>
  • To: krishsingh.111@xxxxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 21 Jan 2020 08:16:50 +0100 (CET)

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: @OracleSK

kunwar singh <krishsingh.111@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l


Other related posts: