Re: Connection pool issues

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

Regards

Lothar

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