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 email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.