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>');
No comments:
Post a Comment