数据库版本：11.2.4.0
操作系统：AIX 6.1
SQL> drop user PATROL2;
*
ERROR at line 1:
ORA-04021:timeout occurred while waiting to lock object
查看SID 242
kill 掉非本地进程
再次DROP 用户正常
MOS：
CAUSE
This is most likely due to following internal bug:
SQL statements that make use of the new GV$() function would acquire a librarycache (KGL) lock for session duration. One example of such a SQL statement is:
SELECT c FROM table(GV$(cursor(select count(*) c from v$active_session_history where is_awr_sample='Y')));
These locks are acquired in shared mode but will block other operations that require an exclusive mode lock.
If you are seeing exclusive library cache locks against GV$ related objects where the holder has acquired the lock in shared mode and has executed a SQL statement that involves a GV$() function then you might be seeing this problem. Unable To Drop User Due to Ora-4021 (文档 ID 2325903.1)
SOLUTION
-
Apply
Patch 21293453
Or use following workarounds:
Kill the blocker session
Or
Stop db console (or cloud control)
编辑推荐：
- ORA-04021: timeout occurred while waiting to lock object03-03
- oracle固定对象到共享池03-03
- [20190706]Same dog, different leash – functions in SQL.txt03-03
- 管理(004)：密码文件 & 用户03-03
- AWR TOP SQL实现03-03
- 解决Win7下Jdeveloper（OAF） 黑屏、卡顿、反应慢的 方法！03-03
- java.lang.IllegalArgumentException:There is no column named SYS_NC00010$03-03
- 关于oracle的Spool命令03-03
相关推荐
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
雷神推出 MIX PRO II 迷你主机：基于 Ultra 200H，玻璃上盖 + ARGB 灯效
2 月 9 日消息，雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C：支持手写笔、第三方安卓应用
2 月 10 日消息，制造商 Musnap 现已在海外推出一款 Oce
