Post queue not processing. Show post showing internal operation:
Example:
Host : <hostname>
Source : o.<SID> Queue : <NAME>
Operations
Target Status Posted Since Total Backlog
---------- --------------- ---------- ------------------ ---------- ----------
o.<SID> Running 193018615 12-Jul-12 17:39:58 1498796 804969
Last operation posted:
Redo log: 7344 Log offset: 732054128
INTERNAL OPERATION "<OWNER>"."<TABLE_NAME>" at 07/11/12 23:23:54
Post processing a large transaction with DLOAD messages with each DLOAD doing several rows Of inserts and making the transaction to be millions of rows
1) On target, set max key cache size to 100
Sp_ctrl> set param SP_OPO_MAX_KEYCACHE_SIZE 100 (default 0)
2) This is a live parameter that takes effect immediately
NOTE: By increasing this parameter to 100,000 rows, it only caches this smaller amount of rows versus all the transaction. In the case of this large transaction, this allows the transaction to complete without issues.
