oracle kill行锁,oracle 锁表查询及kill

--1.查看被锁的表

select session_t.sid,

session_t.serial#,

lock_object.oracle_username,

lock_object.os_user_name,

all_object.object_name,

session_t.username,

session_t.schemaname,

session_t.osuser,

session_t.process,

session_t.machine,

session_t.terminal,

lock_object.locked_mode

from v$locked_object lock_object,

all_objects     all_object,

v$session       session_t

where all_object.object_id = lock_object.object_id

and lock_object.session_id = session_t.sid

order by session_t.sid asc;

--2.根据sid,serial#查杀，假设 sid,serial# 为 156,3443

alter system kill session '156,3443' immediate ;