on 12-02-2009 2:02 PM
Hi,
i tried to issue the SELECT * FROM LOCKSTATISTICS and get no results, exists something wrong with database? i wish to know the better value for REQUEST_TIMEOUT parameter.
Version is: 7.6.03.15
regards
Clóvis
...and yes. about that parameter...
Why do you want to actually change it?
Do you often encounter situations where sessions hang enlessly while they wait for a lock?
regards,
Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Clovis,
ok, so if I get you right you want to limit the time any session waits for a lock.
This can be done via the db parameter REQUEST_TIMEOUT/RequestTimeout.
The SessionTimeout parameter is used to kick out inactive sessions.
It's mainly usefull to prevent situation where new sessions cannot be created because of "zombie" sessions that hang on.
Be aware that although you can set the value to any value within the allowed range, the timeout task will check for it only every 5 seconds.
So don't count on the timing here
regards,
Lars
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.