If you have the rowid, then you can use the DBMS_ROWID package to obtain the object name for the table that holds...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
this row. To obtain the object_id of the table, use the following query:
SELECT DBMS_ROWID.ROWID_OBJECT('rowid') FROM dual;
Make sure you insert your rowid into the function above. Once you know the object_id, you can query V$LOCKED_OBJECT similar to the following:
SELECT session_id,oracle_username,locked_mode FROM v$locked_object WHERE object_id = xx;
Obviously, you will replace 'xx' with the object id returned from your call to DBMS_ROWID.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.