Post stops due to ORA-02049 shortly after it starts. Although the messages in qview shows there are very short and normal transaction.
There is a trigger on the table, and the trigger uses dblink to perform transactions on tables that are on different oracle instance. When trigger with dblink takes longer than DISTRIBUTED_LOCK_TIMEOUT setting in the database, Oracle will terminate the transaction with ORA-02049: timeout: distributed transaction waiting for lock.
If disabling trigger with dblink is possisble, then disable it.
If disabling the trigger is not possible, then one should look into the following to troubleshoot the issue:
Is there a bit map used in the involved tables?
Are there any open transactions on these tables? Check for lock, block, and wait on these tables.
Is there materialized view with refresh on commit setting on these tables?
How fast transactions can be posted using dblink?
Check with Oracle Support to see if DISTRIBUTED_LOCK_TIMEOUT can be changed to a new higher value (the default is 60)
