RE: New Connection for Each Query
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 9 Jun 2008 13:21:05 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
