ORACEL关于表解锁
来源:互联网 发布:淘宝玩具店铺名字 编辑:程序博客网 时间:2024/06/17 03:33
---查询被锁住的表
SELECT A.OWNER,
A.OBJECT_NAME,
B.XIDUSN,
B.XIDSLOT,
B.XIDSQN,
B.SESSION_ID,
B.ORACLE_USERNAME,
B.OS_USER_NAME,
B.PROCESS,
B.LOCKED_MODE,
C.MACHINE,
C.STATUS,
C.SERVER,
C.SID,
C.SERIAL#,
C.PROGRAM
FROM ALL_OBJECTS A,
V$LOCKED_OBJECT B,
SYS.GV_$SESSION C
WHERE ( A.OBJECT_ID = B.OBJECT_ID )
AND (B.PROCESS = C.PROCESS )
AND object_name='{TABLE_NAME}'
ORDER BY 1,2
---查询被锁住的表
SELECT /*+ rule */
S.USERNAME,
DECODE(L.TYPE, 'TM', 'TABLE LOCK', 'TX', 'ROW LOCK', NULL) LOCK_LEVEL,
O.OWNER,
O.OBJECT_NAME,
O.OBJECT_TYPE,
S.SID,
S.SERIAL#,
S.TERMINAL,
S.MACHINE,
S.PROGRAM,
S.OSUSER
FROM V$SESSION S, V$LOCK L, DBA_OBJECTS O
WHERE L.SID = S.SID
AND L.ID1 = O.OBJECT_ID(+)
AND S.USERNAME IS NOT NULL
AND S.TERMINAL = '{USER_PC_NAME}';
---杀掉锁表会话
alter system kill SESSION '1254,123';
select USERENV('sessionid') FROM dual;
SELECT A.OWNER,
A.OBJECT_NAME,
B.XIDUSN,
B.XIDSLOT,
B.XIDSQN,
B.SESSION_ID,
B.ORACLE_USERNAME,
B.OS_USER_NAME,
B.PROCESS,
B.LOCKED_MODE,
C.MACHINE,
C.STATUS,
C.SERVER,
C.SID,
C.SERIAL#,
C.PROGRAM
FROM ALL_OBJECTS A,
V$LOCKED_OBJECT B,
SYS.GV_$SESSION C
WHERE ( A.OBJECT_ID = B.OBJECT_ID )
AND (B.PROCESS = C.PROCESS )
AND object_name='{TABLE_NAME}'
ORDER BY 1,2
---查询被锁住的表
SELECT /*+ rule */
S.USERNAME,
DECODE(L.TYPE, 'TM', 'TABLE LOCK', 'TX', 'ROW LOCK', NULL) LOCK_LEVEL,
O.OWNER,
O.OBJECT_NAME,
O.OBJECT_TYPE,
S.SID,
S.SERIAL#,
S.TERMINAL,
S.MACHINE,
S.PROGRAM,
S.OSUSER
FROM V$SESSION S, V$LOCK L, DBA_OBJECTS O
WHERE L.SID = S.SID
AND L.ID1 = O.OBJECT_ID(+)
AND S.USERNAME IS NOT NULL
AND S.TERMINAL = '{USER_PC_NAME}';
---杀掉锁表会话
alter system kill SESSION '1254,123';
select USERENV('sessionid') FROM dual;
- ORACEL关于表解锁
- oracel
- Oracel
- 表解锁
- 关于oracle的锁表解决session marked for kill
- oracle 锁表解锁
- mysql 锁表解锁
- Oracle 锁表解锁
- plsql锁表解锁
- oracle 锁表解锁
- mysql锁表解锁
- 如何将中被锁表解锁
- SQL表解锁步骤
- [oracle]: 表解锁
- oracle 表解锁
- oracle 表解锁
- oracle表解锁方法
- SQL表解锁步骤
- 重拾遗忘-编程基础-C++
- C++ 实现单例模式 多线程
- 求和式 (C++ 坑爹的<<,>>,%lld)
- 写尽自己一个人的孤独,却写不出心里的寂寞
- strtotime那些事
- ORACEL关于表解锁
- iOS 5中的strong和weak关键字
- vb.net 交错 处理 一年中的月份天数的输出
- 用do while{0}定义宏来定义函数
- rank,dense_rank,row_number使用和区别
- oracle v$librarycache详解
- QX项目实战-4.模型快速开发
- Android下libdvbpsi的使用
- Qt .pro文件解析