Re: script taking time to run on DB

Posted by ErmanArslansOracleBlog on Jul 26, 2018; 8:51am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/script-taking-time-to-run-on-DB-tp6492p6495.html

Your blocked sessions are waiting for blocking session with SID 534.
SID 534 is doing an update and its wait is  latch: cache buffers chains.

latch: cache buffers chains" contention is typically encountered because SQL statements read more buffers than they need to and multiple sessions are waiting to read the same block.          

So concantrate on that update.. concantrate on the where condition..