Re: row cache lock

Posted by ErmanArslansOracleBlog on Dec 28, 2021; 5:54am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/row-cache-lock-tp10531p10532.html

You waited for row cache lock for the following statement ->

drop table TB_MT_TT_PEND_CBS_NEW purge

So it is a drop table purge operation.

We need to see the details about the session to tell you something useful..
There are bugs recorded for these types issues..

We need to check the call stack and the wait details (wait stack) to check the situation properly.