Re: row cache lock

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

There are failure modes in this context, but actually your session could do its job, so it could drop the table, but it seem it took some time and that's your concern..
v$rowcache will give you some hints, but these should be recorded in the trace file.
Don't you see the wait details and the call stack in the trace file?
Can you reproduce the issue? If so, enable trace and reproduce.. Once you reproduce the issue and get the trace, let me see that trace..
A session level 10046 trace will be sufficient for now.