查询数据库哪个表被锁

一、查询数据库哪个表被锁

-- 1、查询引起了锁表的原因
select * from v$sqlarea a, v$session s, v$locked_object l where l.session_id = s.sid and s.prev_sql_addr = a.address order by sid, s.serial#;

-- 2、查询锁表的会话、人员等信息
SELECT * FROM v$locked_object;
SELECT * FROM dba_objects;
SELECT * from v$locked_object a,dba_objects b where b.object_id=a.object_id;

-- 3、根据 object_id查询被锁的表名
SELECT * FROM USER_OBJECTS WHERE OBJECT_ID='13851578'

-- 5、查看表被锁的行
select * from CDELREC for update skip locked;	--被锁的表名

-- 6、查看是哪个session引起的
select b.username,b.sid,b.serial#,logon_time from  v$locked_object a,v$session b where a.session_id = b.sid order by b.logon_time

-- 4、根据会话ID查询本地进程
SELECT * FROM v$session WHERE SID='3306'

-- 7、释放锁住的表
alter system kill session'3306,4565' immediate; 	-- 3716是上一步查到的sid，56137是上一步查到的serial#；