Dbms_rowid
Identifying Locked Rows in Oracle Using v$session
Identifying Locked Rows in Oracle Database using tables v$session and dba_objects Purpose At 09:00 a user reports that an order screen has frozen. The user pressed Save, and nothing happens. The session is not busy with work. It is waiting. Another transaction changed the same row and has not finished, so the database …
Read More