Oracle, how to unlock a table

ayyaayy

Oracle, how to unlock a table

whbilly

select b.sql_text text, a.sid sid, a.serial # sria #, a.username username, c.type type, a.machine machine
from v $ session a, v $ sqltext b, v $ access c
where c.object = upper ('&1')
and c.type in ('TABLE', 'PACKAGE', 'PROCEDURE', 'FUNCTION', 'PACKAGE BODY')
and a.sid = c.sid
and b.address = a.sql_address
and b.hash_value = a.sql_hash_value
order by a.sid, a.serial #, b.piece;

Enter the table name and see what session is in the lock table, kill

ayyaayy

Thank you

wait7788

Agree on the first floor.