Welcome

Wheresoever you go, go with all your heart. (Confucius)

6/19/2012

[Oracle] Identify the locked row id in table described

This sql will get locked id in Table <table_name>

select dbms_rowid.rowid_create(1,row_wait_obj#, row_wait_file#, row_wait_block#, row_wait_row#) from v$session where sid = (select s.sid from dba_objects,  v$lock s where object_id = s.ID1 and object_name = '<table_name>');