Oracle Idle Timeout

[mmuth]

Our Oracle database is set to disconnect users after a period of inactivity. This isn't usually an issue, as enough people are hitting PDMLink to keep the connection active. And if it does get disconnected, it will reconnect with the next user request. However, when only a few people are working (off hours or on weekends), this is disconcerting to our users. And they get weird error messages that don't help them figure out what is happening (usually an access denied type of message).

Are there any properties we can set to get PDMLink to keep the connection alive?

Thanks,

Mary-Ann Muth

KAPL

[jessh]

How about setting wt.pom.connectionCloserIdleTimeout to less than
(Oracle timeout in seconds) - (wt.pom.connectionMonitorSleepInterval),
e.g. to (Oracle timeout seconds) -
(wt.pom.connectionMonitorSleepInterval) - 1.

wt.pom.connectionMonitorSleepInterval defaults to 10, by the way.

--
Jess Holle