Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 10619 invoked from network); 15 Sep 2007 04:17:41 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 15 Sep 2007 04:17:41 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CB2A97433AB; Sat, 15 Sep 2007 04:38:57 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27358-05; Sat, 15 Sep 2007 04:38:57 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7B7A6742E2C; Sat, 15 Sep 2007 04:38:55 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 15 Sep 2007 03:53:55 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B0A747430D2 for ; Sat, 15 Sep 2007 03:53:55 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 10372-04-2 for ; Sat, 15 Sep 2007 03:53:55 -0400 (EDT) Received: from smtp814.mail.ird.yahoo.com (smtp814.mail.ird.yahoo.com [217.146.188.74]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 6B3287437F7 for ; Sat, 15 Sep 2007 03:53:53 -0400 (EDT) Received: (qmail 26704 invoked from network); 15 Sep 2007 08:32:36 -0000 Received: from unknown (HELO Primary) (oracle.expert@btinternet.com@86.130.255.131 with login) by smtp814.mail.ird.yahoo.com with SMTP; 15 Sep 2007 08:32:36 -0000 X-YMail-OSG: sXwAMmgVM1mcAQ0XVjITR3PTmDKWCAW7.Ge1FzY.Tku99Fx9rcIZWmdu353jcbmhqECTHVesH74YwTimTpF5ma6dG4h8jTE5wMyv9qXMTHrHSXrd Message-ID: <009601c7f773$0d30f340$0200a8c0@Primary> From: "Jonathan Lewis" To: References: <20070915071419.33C63743CB5@turing.freelists.org> Subject: Re: Weird database hanging Date: Sat, 15 Sep 2007 09:33:11 +0100 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 X-archive-position: 1590 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: jonathan@jlcomp.demon.co.uk Precedence: normal Reply-to: jonathan@jlcomp.demon.co.uk List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain 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" > 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