关于ORA-04021的解决办法(timeout occurred while waiting to lock object)
来源:互联网 发布:滤水壶哪个牌子好 知乎 编辑:程序博客网 时间:2024/05/18 00:10
某个应用正在锁定该表或者包
表为
select b.SID,b.SERIAL#,c.SQL_TEXT
from v$locked_object a, v$session b, v$sqlarea c
where a.SESSION_ID = b.SID
and b.SQL_ADDRESS = c.ADDRESS
and c.sql_text like '%table_name%'
包为
select B.SID,b.USERNAME,b.MACHINE FROM V$ACCESS A, V$SESSION B WHERE A.SID=B.SID and a.OBJECT = '%PACKAGE_name%' and a.TYPE = 'PACKAGE'
找出这个session
然后 kill
>alter system kill session 'sid,serial#'
表为
select b.SID,b.SERIAL#,c.SQL_TEXT
from v$locked_object a, v$session b, v$sqlarea c
where a.SESSION_ID = b.SID
and b.SQL_ADDRESS = c.ADDRESS
and c.sql_text like '%table_name%'
包为
select B.SID,b.USERNAME,b.MACHINE FROM V$ACCESS A, V$SESSION B WHERE A.SID=B.SID and a.OBJECT = '%PACKAGE_name%' and a.TYPE = 'PACKAGE'
找出这个session
然后 kill
>alter system kill session 'sid,serial#'
0 0
- 关于ORA-04021的解决办法(timeout occurred while waiting to lock object)
- 关于ORA-04021得解决办法(timeout occurred while waiting to lock object)
- ORACLE-关于ORA-04021得解决办法(timeout occurred while waiting to lock object)
- 解决ORA-04021:timeout occurred while waiting to lock object
- ORA-04021:timeout occurred while waiting to lock object ...
- ORA-04021: timeout occurred while waiting to lock object
- 关于等待多长时间会引发ORA-04021: timeout occurred while waiting to lock object错误的猜测
- ORA-04021:timeout occurred while waiting to lock object TEST.PRO_TEST
- OERR: ORA 4021 time-out occurred while waiting to lock object
- ORA-02049: timeout: distributed transaction waiting for lock
- org.eclipse.jdi.TimeoutException:Timeout occurred while waiting for packet 1983.occurred
- org.eclipse.jdi.TimeOutException: Timeout occurred while waiting for packet 220 occurred creating st
- Timeout waiting to lock cp_proj class cache for build file
- 10、android studio :Timeout waiting to lock daemon addresses registry
- Android Timeout waiting to lock daemon addresses registry问题
- Connect to TimesTen failed: ORA-12170: TNS:Connect timeout occurred 问题的解决
- ORA-04020: deadlock detected while trying to lock object 报错问题解决步骤
- Anroid studio遇到的问题5--Gradle sync failed: Timeout waiting to lock cp_proj class cache for build
- 自定义ContentProvider
- leetcode 24. Swap Nodes in Pairs
- python初学(1)字符串
- java入门教程-5.5Java接口和抽象类的区别
- 计算机视觉三大顶级国际会议
- 关于ORA-04021的解决办法(timeout occurred while waiting to lock object)
- ubuntu virualbox 虚拟硬盘扩容
- CityMaker学习教程02 软件的授权
- java39深入同步语法
- for循环 ,listview
- 关于PHP的一些常用的字符串处理函数
- 进程间通信方式
- CV牛人牛事简介之一
- javascript的基础数据类型