RE: All phasis are aborted only cleanup is completed

Posted by ErmanArslansOracleBlog on Jan 13, 2017; 8:25pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/All-phasis-are-aborted-only-cleanup-is-completed-tp1900p1909.html

Hmm, maybe an internal update to the ad_adop_sessions table could the job, but anyways, you managed to workaround it.

For ADZDWRKR; check Database session for understanding what ADZDWRKR.sql does.
It does things like MV recreations.. So maybe that's where it is spending time.

As I said, check the db sessions , the active ones and see what they are doing.