The following messages are observed in target event log when Post slows down on one table:
Error 2018-06-08 17:34:37.662005 3418 7 Poster: DML operation in session 3 has taken 3601 secondsTable "OWNER"."TABLE_NAME" has a bitmap index. Bitmap indexes are not recommended in OLTP. Please convert bitmap index (INDEX_NAME) to a B-Tree index. Poster Exiting. (posting from SID1, queue queue_name, to SID2) [module opo]
Info 2018-06-08 17:34:37.982599 957 1 Poster exited with code=1, pid = 3418 (posting from SID1, queue queue_name, to SID2)
Info 2018-06-08 17:34:37.986241 797 1 Poster launched, pid = 797 (posting from SID1, queue queue_name, to SID2)
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center