In-doubt transaction not automatically cleared by reco

Hi Guys,

There was a reported error on

java.sql.SQLException: ORA-01591: lock held by in-doubt distributed transaction <>

Further investigation results show that during the period when the database was in 10.2.0.4, the distri tran was cleared by oracle in the background automatically.

A recent alert log after the database was updated to 10.2.0.5 shows that even though the distri tran lock occurs, oracle did not proceed to delete the lock.

How is it that the reco services did not proceed to delete the in-doubt transaction? We have to manually clear it which is usually deem as the last resort.

thanks