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