When you issue "show post detail", you may see the output that may not have transactions and DMLs posted adding up to operations posted. Here is a sample output:
sp_ctrl (batch01:2300)> show post detail
Host : batch01
Source : o.KCFCSPLEX Queue : QPAC_KCFC
Operations
Target Status Posted Since Total Backlog
---------- --------------- ---------- ------------------ ---------- ----------
o.KCFCBAT Running 400995 11-May-07 10:24:17 130484 130387
Last operation posted:
Redo log: 13133 Log offset: 104099176
INSERT in "KCFC_USER"."ACLINKC" at 05/09/07 14:54:31
Post state : Commit transaction
Activation Id : 19
Current transaction Id : 2
ID of blocking transaction : 0
Number of open transactions : 0
Number of messages read released : 500
Operations posted : 100
Transactions posted : 5
Insert operations : 50
Update operations : 20
Delete operations : 15
Key cache hit count : 0
SQL cache hit count : 70 %
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center