need help with exception handling

I have a problem with our DB:

In summary, the problem is that when the load on DB is high, the transactions cannot complete. Distributed transactions that do no run to completion are referred to as in-doubt transactions. There is a parameter set in oracle called DISTRIBUTED_RECEIVER_CONNECTION_HOLD_TIME (set to default value of 200 secs) which determines for how long Oracle will keep the in-doubt transaction before it cleans it up. Oracle is not cleaning up hence, these transactions build up over time and slow down DB.

I need to identify an error handling procedure which will identify and retry in-doubt transactions for a fixed number of times. If the transaction does not complete in those tries, I need to write a procedure to clean the transaction. I need to identify this procedure and make sure that it is called in every procedure in use.

I understand that part of the problem is not enough powerful software, but this will be upgraded. On my part, I need some help in writing this error handling procedure.

Thanks for any help.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 10 1999 - 10:17:28 CDT