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