Re: Weird database hanging

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