ORA-04021:timeout occurred while waiting to lock object TEST.PRO_TEST
来源:互联网 发布:淘宝销量累计规则 编辑:程序博客网 时间:2024/06/06 05:20
ORA-04021:timeout occurred while waiting to lock object TEST.PRO_TEST
在用sqldev重新编译存储过程时报如上错误。
解决方法:
1. 查看是否有DDL锁:
select session_id sid, owner, name, type,
mode_held held, mode_requested request
from dba_ddl_locks
where name = 'AP_STATB_SETTLE_PUSHMAIL'
2. 查看是否被锁:
select B.SID,b.USERNAME,b.MACHINE,,B.SERIAL#
FROM V$ACCESS A, V$SESSION B
WHERE A.SID=B.SID
and a.OBJECT = '存储过程名字'
and a.TYPE = 'PACKAGE'
3. 查出SESSION对应的spid:
select s.username,s.status,s.sid,p,spid
from v$session s,v$process p
where s.paddr=p.addr
and s.sid=xxx;
4. 杀掉会话:
alter system kill session ‘sid,serial#’;
如果session状态为killed,直接登录操作系统,杀掉进程:
Kill -9 spid
- ORA-04021:timeout occurred while waiting to lock object TEST.PRO_TEST
- 解决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)
- 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错误的猜测
- 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问题
- ORA-04020: deadlock detected while trying to lock object 报错问题解决步骤
- Timeout waiting for idle object
- Oracle 9i 升级中的bug-- Sys.Cdc_alter_ctable_before ORA-04020 deadlock detected while trying to lock object
- VIM-adventures
- Linq to sql :查询句法---where
- 【技术文档】百度搜索技巧
- dispatch_group_t 等待功能
- 郑厂长系列故事——排兵布阵
- ORA-04021:timeout occurred while waiting to lock object TEST.PRO_TEST
- XMPPFrameWork IOS 开发(六)聊天室
- oracle学习笔记(3)_PL/SQL 和orcle服务
- String
- 威威猫系列故事——打地鼠
- 在Iframe中调用父子页面的js方法
- iOS5可能会删除本地文件储存
- Linux驱动入门——构建和运行模块
- Linq to sql :查询句法---orderby