On Wed, Oct 28, 2009 at 12:32 AM, Kulasekaran, Raja <raja.kulaseka...@netapp.com> wrote: > So, How to I control this ?. Is it possible to reuse the existing > connection ?.
It should be doing that already. Each process will open one connection and keep it open (unless you use different connection parameters, like a different login), reusing it each time. What you can't do is share a single connection between multiple processes. If the number of connections to Oracle is a problem for you, there are several tools out there that can help. You'll find discussion of them in the mailing list archives. The first thing to do is make sure you have a proxy in front of your mod_perl server. - Perrin