Re: Extremely high "connection management call elapsed time"
Date: Wed, 28 Oct 2009 11:47:10 -0700
Looking at the docs it seems that some app is doing many connects/disconnects on the database.
You could query dba_audit_session and see how many logons are occurring, and the host and account used.
I don't know what kind of application is using the database, but could the time correspond to a time that usage might be expected to increase?
On Wed, Oct 28, 2009 at 11:35 AM, Chen Shapira <cshapi_at_gmail.com> wrote:
> Hi Oracle-L,
> I am wondering if anyone here ran into a situation where "connection
> management call elapsed time" timed statistic accounted for 83% of
> total DB time. We are also seeing long waits on "Library cache load
> lock" with very high rates of timeout on this wait (91% timeout).
> This happens once every day or two, lasts two hours and then goes away
> on its own. It doesn't seem to coincide with our regular peak activity
> times or large reports, or backups or anything like this.
> If you have suggestions on where I should look or what could be a
> possible cause for what I am seeing, I'd appreciate it a lot!