ITPub博客

首页 > 数据库 > Oracle > 当删除oracle数据库user时发生row cache lock 等待事件

当删除oracle数据库user时发生row cache lock 等待事件

原创 Oracle 作者:paulyibinyi 时间:2019-02-19 14:45:57 0 删除 编辑

在oracle数据库中做的动作如下:

drop user abc; hang住,等待事件为 row cache lock

Hanganalyze   显示

===============================================================================
 
Chains most likely to have caused the hang:
 [a] Chain 1 Signature: 'enq: TT - contention'<='row cache lock' (cycle)
  Chain 1 Signature Hash: 0x4a0d0d64
 [b] Chain 2 Signature: 'row cache lock'<='row cache lock' (cycle)
  Chain 2 Signature Hash: 0x75bdd0c
 [c] Chain 3 Signature: 'row cache lock'<='row cache lock' (cycle)
  Chain 3 Signature Hash: 0x75bdd0c
 
===============================================================================
Cycles:
 
-------------------------------------------------------------------------------
Chain 1:
-------------------------------------------------------------------------------
  Oracle session identified by:
  {
  instance: 1 (uouk2oas.uouk2oas1)
  os id: 15866
  process id: 197, oracle@uklpdufms01a (DW05)
  session id: 1193
  session serial #: 29877
  }
  is waiting for 'row cache lock' with wait info:
  {
  p1: 'cache id'=0xa
  p2: 'mode'=0x0
  p3: 'request'=0x3
  time in wait: 1.731862 sec
  heur. time in wait: 1871 min 58 sec
  timeout after: 1.268138 sec
  wait id: 489490
  blocking: 6 sessions
  current sql: BEGIN
  SYS.KUPW$WORKER.MAIN('SYS_IMPORT_FULL_08', 'SYS', 0); >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
 END;



impdp 导入数据操作阻止了drop user 的操作,


解决方法:

1:  取消impdp导数操作

2:重新运行drop user操作


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7199859/viewspace-2636370/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论
学习数据库

注册时间:2007-12-11

  • 博文量
    902
  • 访问量
    6577219