Re: Weird database hanging

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
--
http://www.freelists.org/webpage/oracle-l

Other related posts: