Re: Actulaize_all stuck

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/Actulaize-all-stuck-tp9084p9085.html

This may be related with the optimizer.
Did you collect stats recently?
If it is waiting in the db, then you should check the db first.. Check the session and try to find the wait first..
It may be related with the system stats.. This is mentioned in here ->
https://www.oracle.com/webfolder/community/oracle_e-business_suite/4344959.html
There is a unapproved solution and it is done by deleting the SYS stats.. But this is a risk move, but it may help.. I didnt test it.. The risk is yours.