cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X

Oracle Idle Timeout

mmuth
1-Newbie
1-Newbie
‎Mar 10, 2014 09:57 AM
‎Mar 10, 2014 09:57 AM

Oracle Idle Timeout

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

Labels:
0 Kudos
Notify Moderator
1 REPLY 1
jessh
5-Regular Member
5-Regular Member
(To:mmuth)
‎Mar 10, 2014 10:40 AM
‎Mar 10, 2014 10:40 AM

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

0 Kudos
Notify Moderator
Top Tags