Skip to main content
1-Visitor
March 10, 2014
Question

Oracle Idle Timeout

  • March 10, 2014
  • 1 reply
  • 908 views

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

1 reply

12-Amethyst
March 10, 2014
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