event_logに出力される 「Post Main thread is waiting seconds for session to commit before processing next operation.」 について
説明
Post プロセスがメッセージの処理を行っていないもしくは処理がとても遅い場合があります。 そのとき、event_log では次のメッセージが出力されています。
Notice 2015-04-09 10:37:30.477723 5982 7 Poster: Operation ODR_UPDATE1 on table "OWNER"."TABLE" is taking longer than 120 seconds. SID/serial: 9999/9998 Subqueue: 37. (posting from SOURCEDB, queue POST_QUEUE1, to TARGETDB) [module opo]
Warning 2015-04-09 10:37:48.592152 6263 1 Poster: Main thread is waiting 479 seconds for session 819 to commit before processing next operation. (posting from SOURCEDB, queue POST_QUEUE1, to TARGETDB) [module opo]
Warning 2015-04-09 10:40:51.615779 6263 1 Poster: Main thread is waiting 659 seconds for session 819 to commit before processing next operation. (osting from SOURCEDB, queue POST_QUEUE1, to TARGETDB) [module opo]