Return
-
Title
Post too slow, status always "WAITING" or Reader Slow -
Description
Post too slow for all transactions and all tables, less than 100 messages per second. This applies to other shareplex processes such as Reader . Similar diagnostics need to be done to identify the issue.
1.show post detail shows "Post state" always Waiting.
sp_ctrl (splx-vip:2300)> show post detailHost : splx-vip
Source : o.SPLX_SOURCE Queue : splx-vipOperations
Target Status Posted Since Total Backlog
---------- --------------- ---------- ------------------ ---------- ----------
o.GSDLYX Running 18916 31-Mar-11 15:10:32 0 169936897Last operation posted:
Redo log: 31333 Log offset: 361200816
COMMIT "SGPM_OUT"."S_WKS_DEAL" at 03/26/11 22:09:25Post state : Waiting
Activation Id : 15
Last operation transaction id : 6
Number of open transactions : 4
Number of active transactions : 0
Number of messages read released : 12595944Number of threads : 4
Number of sessions : 6
Peak number of sessions : 6
Number of Oracle connections : 7
Concurrency (Active sessions) : 0
Number of pending messages : 0Operations posted : 18916
Transactions posted : 32Full rollbacks : 0
Full rollback operations posted : 0
Rollback operations skipped : 0Insert operations : 8326
Update operations : 95
Delete operations : 10462Insert batch operations / average : 249 / 33 rows
Update batch operations /2. read is slow when capture is on the same pace with Oracle redoRead timing debug shows high number for queue reads, which indicates it is spending time outside of Shareplex. Most likely it is related to select call bug if customer is HP-UX 11.31 IA
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.