Re: Weird database hanging

Jonathan, we don't use ASMM, and so the only entries in that view are from the instance startup.

I did move the block change tracking file to another disk last night. However, the error *just* happened again. For the first x minutes there was no activity in the alert log, however the CTWR process was on top of `top`. After a while I saw those PMON latch errors and the other errors that I reported earlier.

This happened to occur during one of our bulk loads.

I'm wondering if Confio Ignite might be causing some grief. I've been running it for evaluation. Has anyone had any problems like this?

Don.

On 9/15/07, Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> Given the comments from later posts, one of the
> things I would check is v$sga_resize_ops to see
> if your latch and buffer problems appeared when
> the shared pool was shrinking.
> http://jonathanlewis.wordpress.com/2007/04/16/sga-resizing/
>
> Regards
>
> Jonathan Lewis
> http://jonathanlewis.wordpress.com
>
> Author: Cost Based Oracle: Fundamentals
> http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
> ----- Original Message -----
> > Date: Fri, 14 Sep 2007 13:19:45 -0500
> > From: "Don Seiler" <don_at_seiler.us>
> > Subject: Weird database hanging
> >
> > Running 10gR2 (10.2.0.2) on RHEL4 on 4 64-bit dual-core box. Earlier
> > today users complained en masse about not being able to connect to the
> > database. I got to a term and found that even trying to log in
> > locally as sysdba was hanging.
> >
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Don Seiler
oracle: http://ora.seiler.us
ultimate: http://www.mufc.us
--
http://www.freelists.org/webpage/oracle-l