I’ve got a very low traffic site running against Oracle. The monitors
show my ruby processes holding their database connections for the
maximum time configured, at which time they are “sniped”. I am relying
on Rails to properly reconnect when necessary - I haven’t seen any
errors indicating that it is not doing that.
I’ve been asked if Rails can be configured to do its own idle connection
management, closing them after a given period of time and then only
reconnecting when necessary.
I have no idea. Can somebody help me out? It’s a small app and a small
number of connections, I think the ops guys just want to clean up their
monitoring report. But, still, it’d be good information to know.