oracle locked by transaction
来源:互联网 发布:淘宝达人申请直播入口 编辑:程序博客网 时间:2024/06/14 15:54
正在调试代码,大半夜的遇到这么一个问题,着实让人心塞塞。不过已经解决了,现在记录一下。
我用了navicat可视化界面的工具,所以就直接连接了自己的数据库
然后新建查询,输入—SELECT s.username,l.OBJECT_ID,l.SESSION_ID,s.SERIAL#,l.ORACLE_USERNAME,l.OS_USER_NAME,
l.PROCESS FROM V$LOCKED_OBJECT l,V$SESSION S WHERE l.SESSION_ID=S.SID;
这时候可以查到SESSION_ID和SERIAL#
关键的一步就是
alter system kill session '200,348';
其中200是SESSION_ID,348是SERIAL#的值。就可以解决了。
0 0
- oracle locked by transaction
- 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 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?解锁
- 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 问题解决办法
- 案例分析:某企业FTP服务动态密码验证模块存在的问题及建议
- 误删appcompat v7后,怎么创建appcompat v7项目。
- 使用SSL加密与Kubernetes apiServer的通信
- Android-Activity-Life
- 欢迎使用CSDN-markdown编辑器
- oracle locked by transaction
- 一个误用snprintf的bug分析
- Android recyclerview 多个布局 item数据错乱
- 如何借鉴电影中的表达方式
- 八数码经典
- storm和kafka结合的一个小问题
- NYoj 26 孪生素数问题
- Linux:守护进程解析、如何实现守护进程
- Linux:守护进程详解及实现