TIMEOUT setting -- what is it? [message #60003] |
Thu, 08 January 2004 20:37 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Mark K
Messages: 18 Registered: October 2003
|
Junior Member |
|
|
My customer's software developmer is asking to "increase the timeout value -- double it -- on the Oracle server".
I don't know if I'm blanking out here, but what TIMEOUT values is he talking about? I don't know of any init.ora TIMEOUT parameter.... I'm blanking. Ideas anyone?
-- Mark K.
|
|
|
|
Re: TIMEOUT setting -- what is it? [message #60008 is a reply to message #60003] |
Fri, 09 January 2004 00:46 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Frank Naude
Messages: 4590 Registered: April 1998
|
Senior Member |
|
|
Hi,
My guess is they're talking about the DISTRIBUTED_LOCK_TIMEOUT parameter.
This parameter specifies the amount of time (in seconds) for distributed transactions to wait for locked resources. If your developers are getting "ORA-2049: timeout: distributed transaction waiting for lock" errors, you can increase this parameter.
Best regards.
Frank
|
|
|
|