Re: Urgent problem : Plz help
Date: Thu, 19 Mar 2009 07:52:58 -0700
Message-Id: <200903191452.n2JEqw9h021258_at_rm-rstar.sfu.ca>
('binary' encoding is not supported, stored as-is)
- Connection pooling.
You can either have connection pooling at the DB or at the application level.
You already mentioned you do not use connection pooling at the DB level.
Looks like an application connecting to your database is not using connection pooling either. Looks like it is opening a new connection for every query. It also looks like it is not closing the connections properly after use.
It is good database coding practice to be using connection pooling at the application level. That way, only a set number of connections are opened and are kept open and reused, reducing the load on resources. This also speeds up queries since connections don't have to be opened for each query.
Make sure to communicate that to the app developers.
2) One way to check who is opening all the connections is to use the OS command:
netstat -an
Try to find all the ip addresses connecting to the database server and track it down and find your culprit.
--
Lyndon Tiu
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 19 2009 - 09:52:58 CDT