Post gets killed due to dead locking
Event_log:
Warning 2011-02-02 03:13:34.552980 29953 1 Poster: Main thread waiting for syncop.done for xxx seconds
Warning 2011-02-02 03:14:34.359368 29953 7 Poster: DML operation exceeded SP_OPO_MAX_OEXN_TIME. Cause is unknown. Notice 2011-02-02 03:14:36.871177 600 1 Poster: Killing session sid=5901 serial=83
Post main thread starts killing sessions and relaunches itself when it has dispatched the commit to a child sql thread and that sql thread did not finish the commit within 5 times the SP_OPO_MAX_OEXN_TIME setting (seconds).
SP_OPO_MAX_OEXN_TIME: This parameter controls the maximum duration, in seconds, that a SQL thread may spend in a call to OCIStmtExecute ( ) before the timekeeper thread defaults to a deadlocked position and forces the Multi-threaded Post process to exit.
