Re: Connection pool issues

From: Lothar Flatz <>
Date: Thu, 26 Feb 2015 18:50:52 +0100
Message-ID: <>

  Hi Sandra,

what does GridControl say? ASH? Sql*Monitor? AWR? Is the only diagnostics tool you using longops? Why?



On 26.02.2015 18:30, Sandra Becker wrote:
> Oracle - EE
> 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


Received on Thu Feb 26 2015 - 18:50:52 CET

Original text of this message