As far as I know it is not deterministic to find a sql statemnet that is hold a lock, if the session still connected but
and many other sql statement have been executed for the locking session.
the blocking session in v$session does not have correct sql_id which is responsible for holding the lock.
Is the a procedure to univocally identify teh sql statemnet responsible for holding lock in a table row ?