查看Oracle锁表语句
来源:互联网 发布:wifi无法识别的网络 编辑:程序博客网 时间:2024/04/28 08:32
1、查看被锁表
SELECT sess.sid, sess.serial#, lo.oracle_username, lo.os_user_name, ao.object_name, lo.locked_mode
FROM v$locked_object lo, dba_objects ao, v$session sess
WHERE ao.object_id = lo.object_id
AND lo.session_id = sess.sid;
2、查看锁表进程
SELECT * FROM v$session t1, v$locked_object t2 WHERE t1.sid = t2.session_id;
3、kill session
alter system kill session '14,397'; --14:SID,397:SERIAL#
- 查看Oracle锁表语句
- oracle查看锁表语句
- oracle 查看建表语句
- 查看oracle建表语句
- Oracle Pl/Sql 查看建表语句
- Oracle之查看建表语句
- oracle检查锁表语句
- 查询oracle锁表语句
- oracle 查询锁表语句
- oracle 关于表语句
- oracle建表语句
- 修改oracle表语句
- Oracle建表语句
- oracle解锁表语句
- oracle建表语句
- Oracle建表语句
- oracle建表语句
- 如何查看Oracle数据表的建表语句
- c#线程Lock
- WPF之动画
- Oracle中使用fetch bulk collect into批量读取游标数据
- Configuration RAC 11G on Virtualbox
- sparkstream错误总结
- 查看Oracle锁表语句
- Hadoop魅影
- artDialog 框架穿越
- 怎样删除MSHFlexGrid控件中指定的记录
- Foundation:响应式前端框架
- NYOJ +-字符串
- 按层遍历二叉树
- 玩转数组/指针实参
- 制作日历——01