Extremely high "connection management call elapsed time"
Date: Wed, 28 Oct 2009 11:35:42 -0700
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!
ChenReceived on Wed Oct 28 2009 - 13:35:42 CDT