Re: Weird database hanging
- From: "Don Seiler" <don@xxxxxxxxx>
- To: "Jeremiah Wilton" <jeremiah@xxxxxxxxxxx>
- Date: Fri, 14 Sep 2007 16:33:02 -0500
Actually those Concurrency events regarding latches had 0 time_waited.
The events that did have some time were "os thread startup" events
from CJQ0.
Sounds like Oracle trying to kick off scheduled jobs? I'll check the
job history.
Don.
On 9/14/07, Don Seiler <don@xxxxxxxxx> wrote:
> The two largest items are Concurrency and Other. The concurrency
> events deal with latches (shared pool and library cache). The Other
> events deal with "block change tracking buffer space" and "latch
> free".
>
> There is also a large number of "Configuration" class events, but
> those come at 11:28, after all the fun, so might just be another
> symptom.
>
--
Don Seiler
oracle: http://ora.seiler.us
ultimate: http://www.mufc.us
--
//www.freelists.org/webpage/oracle-l
Other related posts:
