Re: Weird database hanging

From: Don Seiler <don_at_seiler.us>
Date: Fri, 14 Sep 2007 16:33:02 -0500
Message-ID: <716f7a630709141433k340b7308u5f89a3ee09fd3666@mail.gmail.com>

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_at_seiler.us> 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

Received on Fri Sep 14 2007 - 16:33:02 CDT