如何解決當(dāng)刪除oracle數(shù)據(jù)庫(kù)user時(shí)發(fā)生row cache lock等待事件

這篇文章主要介紹了如何解決當(dāng)刪除oracle數(shù)據(jù)庫(kù)user時(shí)發(fā)生row cache lock等待事件，具有一定借鑒價(jià)值，感興趣的朋友可以參考下，希望大家閱讀完這篇文章之后大有收獲，下面讓小編帶著大家一起了解一下。

在oracle數(shù)據(jù)庫(kù)中做的動(dòng)作如下:

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 導(dǎo)入數(shù)據(jù)操作阻止了drop user 的操作，

解決方法:

1:  取消impdp導(dǎo)數(shù)操作

2：重新運(yùn)行drop user操作

感謝你能夠認(rèn)真閱讀完這篇文章，希望小編分享的“如何解決當(dāng)刪除oracle數(shù)據(jù)庫(kù)user時(shí)發(fā)生row cache lock等待事件”這篇文章對(duì)大家有幫助，同時(shí)也希望大家多多支持億速云，關(guān)注億速云行業(yè)資訊頻道，更多相關(guān)知識(shí)等著你來(lái)學(xué)習(xí)!