adop phase=cleanup was taking a lot of time on package DBMS_SYS_SQL and Library cache pin event
SQL> SELECT s.sid, s.username, s.program, s.module from v$session s where module like '%AD_ZD%'; SID USERNAME ---------- ------------------------------ PROGRAM ------------------------------------------------ MODULE ---------------------------------------------------------------- 214 SYSTEM sqlplus@ip-172-31-46-159.ec2.internal (TNS V1-V3 AD_ZD SQL> select event from v$session where sid=214; EVENT ---------------------------------------------------------------- library cache pin SQL> select decode(lob.kglobtyp, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER', 4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE', 7, 'PROCEDURE', 8, '...