I don’t quite understand what you mean by setting up a front-end proxy. What would you expect this “proxy” do? Does it take HTTP request?
From: Perrin Harkins <firstname.lastname@example.org>
Date: Thursday, November 13, 2014 at 12:50 PM
To: Xinhuan Zheng <email@example.com>
Cc: Dr James Smith <firstname.lastname@example.org>, mod_perl list <email@example.com>
Subject: Re: Disconnect database connection after idle timeout
On Thu, Nov 13, 2014 at 12:19 PM, Xinhuan Zheng <firstname.lastname@example.org> wrote:
Having another tier (like DBD::Gofer) looks like really messy in infrastructure plus it’s not certain who is going to maintain that module’s quality.
I'd only recommend trying it after you set up a front-end proxy, tune your mod_perl configuration, and use any Oracle tools available to you.