Is it possible to find out whether a particular table is locked by a single session, using SQL commands?
I know that using V$Lock, it should be possible, however,
I think this needs two sessions, i.e one session should have locked a row, and another waiting to acquire the same row.
My question is, if we have only one session, which has acquired lock on a row, and no other session waiting for that row, how to find out?