Home » RDBMS Server » Server Administration » TIMEOUT setting -- what is it?
TIMEOUT setting -- what is it? [message #60003] Thu, 08 January 2004 20:37 Go to next message
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 #60004 is a reply to message #60003] Thu, 08 January 2004 20:46 Go to previous messageGo to next message
sachin kumar gupta
Messages: 157
Registered: March 2003
Senior Member
There is no timeout parameter in init.ora. I guess it may be the LOG_CHECKPOINT_TIMEOUT which specifies the maximum no. of seconds before another CHKPT will occur.

Regards,
Sachin
Re: TIMEOUT setting -- what is it? [message #60008 is a reply to message #60003] Fri, 09 January 2004 00:46 Go to previous messageGo to next message
Frank Naude
Messages: 4580
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
Thanks. Waiting on developers for more info... [message #60020 is a reply to message #60008] Fri, 09 January 2004 10:19 Go to previous message
Mark K
Messages: 18
Registered: October 2003
Junior Member
... specifically what, if any, ORA errors they get.

-- Mark.
Previous Topic: need ur help
Next Topic: index use rate
Goto Forum:
  


Current Time: Fri Sep 20 10:39:51 CDT 2024