Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to solve the row cache lock waiting event when deleting oracle database user, which has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to know about it.

The actions done in the oracle database are as follows:

Drop user abc; hang resides, and the waiting event is row cache lock

Hanganalyze display

=

Chains most likely to have caused the hang:

[a] Chain 1 Signature: 'enq: TT-contention' >

END

The impdp import data operation blocks the operation of drop user

Solution:

1: cancel impdp derivative operation

2: rerun the drop user operation

Thank you for reading this article carefully. I hope the article "how to solve the row cache lock waiting event when deleting oracle database user" shared by the editor is helpful to everyone. At the same time, I also hope you can support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.