can't serialize access for this transaction - Performance Issue

[Former Member]

Hi,

We are getting the error "ORA-08177: can't serialize access for this transaction" when the sender JDBC channel tries to update records on the sender ORACLE database. In the next poll the records are updated successfully.

How can we improve the performance of this channel.

Please advice.

Regards,

Pranav

[prateek]

Goto JDBC sender Advance mode, change your Transaction Isolation level to read_committed and try again.

Regards,

Prateek

[jose_augastine3]

Hi Pranav,

ORA-08177: can't serialize access for this transaction

Cause: Encountered data changed by an operation that occurred after the start of this serializable transaction.

Action: In read/write transactions, retry the intended operation or transaction.

Hope this helps !!!

Regards,

J Augastine