Return
-
Title
Post slow on short transactions -
Description
Post too slow when there are lots of small transactions.
sp_ctrl>show post detail
sp_ctrl>r 10 1
Sometimes Post state is "Waiting", although Backlog is huge.
For examaple:
Target Status Posted Since Total Backlog
---------- --------------- ---------- ------------------ ---------- ----------
o.dzkp1bak Running 595312269 24-Dec-10 10:55:02 0 415310Last operation posted:
Redo log: 137695 Log offset: 83773712
UPDATE of "ETS"."ETS_COUPON" at 03/07/11 08:42:05Post state : Waiting
Activation Id : 5
Last operation transaction id : 3
Number of open transactions : 1
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.