Oracle Record is Locked by anther user 表被锁
来源:互联网 发布:c语言编程软件 编辑:程序博客网 时间:2024/06/05 05:25
引起原因:由于在PL/SQL中更新记录后没有Commit就关闭了窗口所导致,表被锁。
解决方法如下:
1.查看信息
select t2.username,t2.sid,t2.serial#,t2.logon_time from v$locked_object t1,v$session t2 where t1.session_id=t2.sid order by t2.logon_time;
2.执行如下命令
--alter system kill session 'sid,serial#';
alter system kill session '123,4567'; ---123 代表sid查询出的结果, 4567代表serial#查询出的结果
- Oracle Record is Locked by anther user 表被锁
- oracle record is locked by another user
- Oracle 解锁Record is locked by another user?
- ORACLE解锁 record is locked by another user
- Oracle 数据库 Record is locked by another user 问题解决办法
- ORACLE解锁record is locked by another user
- Oracle操作报错:record is locked by another user
- Oracle Record is locked by another user 解决方法
- Oracle 数据库 Record is locked by another user 问题解决办法
- Oracle 数据库 Record is locked by another user 问题解决办法
- Oracle 数据库 Record is locked by another user 问题解决办法
- Oracle 解锁:Record is locked by another user
- ORACLE record is locked by another user?解锁
- Record is locked by another user --Oracle行锁解锁
- ORACLE解锁record is locked by another user
- Record is locked by another user --Oracle行锁解锁
- 关于 oracle record is locked by another user 问题解决办法
- Oracle 数据库 Record is locked by another user 问题解决办法
- c++ cout 格式化输出示例
- VS2010\2008中不能新建项目问题的解决
- RUIM卡
- zoj 1204
- Android 2.3 如何去除camera的gps定位
- Oracle Record is Locked by anther user 表被锁
- Ubuntu 系统中汉字不能显示的修正方法[持续添加中]
- 初装Linux网络优化
- Android全屏绘制 Surface的使用
- 要养成良好的书写Sql的习惯 ---------转自wanghangzhou1984
- 从甲乙丙的关系看自然语言理解的“第二路径”
- php 今天星期几
- in和exists的区别与SQL执行效率分析
- 计算质数