Login  Register

RE: All phasis are aborted only cleanup is completed

Posted by ErmanArslansOracleBlog on Jan 16, 2017; 7:52am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/All-phasis-are-aborted-only-cleanup-is-completed-tp1900p1916.html

Hmm..

I don't your environment, but it seems a little bit long :)

If it didn't encounter any errors, then it is at least something to be happy.

This issue is closed then.

However, you can do patch analysis and drill down to the jobs that have been executed for a long duration of time. You can use Patch Reporting Utilities for this.
These patch reporting tools gives you the ability to check the exceptions that are encountered while applying patches and patch-related timing information.

To use the Applied Patches Reporting tool, you log in to EBS and use the Patching and Utilities link
defined in the System Administrator responsibility under Oracle Applications Manager.

Also, as I mentioned earlier, please do your plan to execute the following in a appropriate time;

exec DBMS_STATS.GATHER_DICTIONARY_STATS;
exec DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;

These will give you benefit in dictionary related queries. (like the ones you saw in your last cutover session)