Oralce 数据库表被锁
Oralce 数据库表被锁
查看Oralce表被锁
- SELECT /*+ rule*/
- a.sid, b.owner, object_name, object_type
- FROM v$lock a, all_objects b
- WHERE TYPE = 'TM'
- and a.id1 = b.object_id;
接触被锁的表
- SELECT sid,serial# FROM v$session WHERE sid = &sid;
- alter system kill session 'sid,serial#';
更多Oracle相关信息见Oracle 专题页面 http://www.bkjia.com/topicnews.aspx?tid=12
评论暂时关闭