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@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.



--
http://www.freelists.org/webpage/oracle-l

Other related posts: