Apply process slow in logical standby after upgrade 12.2 to 19.3
Apply process slow in logical standby after upgrade 12.2 to 19.3 with the following Query and output:
SQL> Select PID, TYPE, STATUS From V$LOGSTDBY Order by HIGH_SCN;
APPLIER ORA-16125: large transaction 10 8 7158672 is waiting for more data
APPLIER ORA-16125: large transaction 2 5 2495157 is waiting for more data
APPLIER ORA-16125: large transaction 24 29 2646351 is waiting for more data
PREPARER ORA-16127: stalled waiting for additional transactions to be applied
COORDINATOR ORA-16116: no work available
APPLIER ORA-16113: applying change to table or sequence "CDS_POST"."AUDIT_DETAIL"
ANALYZER ORA-16116: no work available
BUILDER ORA-44604: Barrier synchronization on DDL with XID 35.19.2166035 (waiting on 6 transactions)
PREPARER ORA-16127: stalled waiting for additional transactions to be applied