Find the user - TechRepublic
General discussion
April 11, 2001 at 11:29 AM
seefet

Find the user

by seefet . Updated 25 years, 2 months ago

I would like to identify the user who has a specific table row locked from another user that initiates a SELECT … WHERE ROWID = … FOR UPDATE ON … NOWAIT for that same row. Is it possible to determine who has that lock in this case?
The purpose is to find out if a table row is locked before another tries to update that row. There will be no one waiting on the currently locked row.

This discussion is locked

All Comments