Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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:19:14 CDT