Connection pool issues
Date: Thu, 26 Feb 2015 10:30:14 -0700
Message-ID: <CAJzM94AApzaWaGBHvS_GukEVGWVzWsdDQ_BaZ4XgvEpGiWMASQ_at_mail.gmail.com>
Oracle - EE 11.2.0.2
This week users started having issues connecting to a database. Error below:
Could not retrieve documents from the docStore: exception was com.ghx.docstore.DocStoreException: Cannot get Connection to: db_arch
In the log someone also saw
Caused by: oracle.ucp.UniversalConnectionPoolException: All connections in the Universal Connection Pool are in use
Obviously, something isn't releasing the connection back to the pool. I've queried longops to no avail. I've seen sessions using a tremendous amount of CPU or I/O. When those sessions were killed, we see an immediate uptick in processing. The only change to the database occurred last Friday--we removed the oldest year of data from partitioned tables and rebuilt unusable indexes. No code releases were done.
My question: Is there anything I can query to see what session(s) are causing the problem other than what I'm already doing?
Any suggestions are appreciated.
--
Sandy
GHX
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 26 2015 - 18:30:14 CET