ロック

●ロック確認
select session_id,object_id,ORACLE_USERNAME from v$locked_object;

select sid, serial# from v$session where sid=59;

select object_name from user_objects where object_id=626777;

●ロック解除
alter system kill session '59,198';