RE: New Connection for Each Query

What is the full Oracle version?

Verify that each connection is exited before the application opens another session.

A statspack report for a short 5 or 10 minute interval should prove helpful in determining the performance problem.

What kind of application is it? Under the assumption that you have verified that connection pooling is not in use by the application can connection pooling be implemented?

• Mark D Powell -- Phone (313) 592-5148

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Charlotte Hammond Sent: Monday, June 09, 2008 7:10 AM
To:
Subject: New Connection for Each Query

Hi All,
I have inherited an application which opens a new connection to the database every single time it executes a query. The CPUs are all maxed out despite the fact that each individual query is trivial and runs << 1 second. I'm guessing that it's the load of establishing all these connections all the time which is causing the problem. 1. How can I confirm/refute this guess?
2. Assuming that this is the problem (and that I have no access to change the application source code), what can I do? Can shared server / CMAN help here at all? Anything else? Any suggestions very much appreciated!
Thank you
Charlotte        

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jun 09 2008 - 12:21:05 CDT