Runnning adpatch to upgrade from R12.1.1 to R12.1.3 - how to speed up UTL_RECOMP.RECOMP_PARALLEL
Upgrading from R12.1.1 to R12.1.3 - applying adpatch 9239089 - R12.AD.B.delta.3
adpatch is sitting at UTL_RECOMP.RECOMP_PARALLEL..
Per adpatch log :
STRT_TASK: [Run ST parallel compile (APPS)] [] [Fri Mar 09 2018 08:50:54]
sqlplus -s APPS/***** @/r05/oracle/apps/apps_st/appl/ad/12.0.0/sql/adutlrcmp.sql APPLSYS ***** APPS ***** ***** 2 0 NONE FALSE
Arguments are:
AOL_schema = APPLSYS, AOL_password = *****,
Schema_to_compile = APPS, Schema_to_compile_pw = *****,
SYSTEM_password = *****, Total_workers = 2, Logical_worker_num = 0
Object_type_to_not_compile = NONE
Use_stored_dependencies = FALSE
- Connected.
Running utl_recomp.recomp_parallel(2), if it exists
OWNER NUM_INVALID
------------------------------ -----------
APPLSYS 2
APPS 21157
CTXSYS 5
XXX_ELS 3