We can find out the table which has been locked ( row-level) at a particular moment using v$lock, dba_dml_locks etc.
But can we find out the "ROWIDS" which has been locked at a particular moment ???
Printable View
We can find out the table which has been locked ( row-level) at a particular moment using v$lock, dba_dml_locks etc.
But can we find out the "ROWIDS" which has been locked at a particular moment ???
I don't know of a methodology for doing that in general -- row lock info is stored at a low level within the table blocks themselves, not in any list external to the table, and i don't think there's a way of accessing the info directly.