Single-threaded Post (STP) is observed to be very slow and the Post state shows Skip records for rollback:
sp_ctrl >show post detail
Host : hostname
Source : o.SID Queue : queue_name
Operations
Target Status Posted Since Total Backlog
---------- --------------- ---------- ------------------ ---------- ----------
o.SID1 Running 7738924 11-Aug-09 17:22:54 13023273 5283873
Last operation posted:
Redo log: 499498 Log offset: 508826700
UPDATE of OWNER.TABLE_NAME at 08/11/09 16:28:35
Post state : Skip records for rollback
Activation Id : 125
Current transaction Id : 23
ID of blocking transaction : 0
.
.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center