Oracle Applications

How to monitor long running 12.2 ADOP abort or cleanup sessions progress

Sometimes adop phase=cleanup or abort runs very long and will not show you any progress on the screen.

Use following SQL's to check the session.

select sid,serial#,inst_id,module,to_char(logon_time,'DD-MON-YYYY HH24:MM') from gv$session where module like '%perl%';

select * from apps.ad_zd_logs order by log_sequence desc;


========================================================================