From oracle-l-bounce@freelists.org Tue Apr 27 11:19:40 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3RGJP814210 for ; Tue, 27 Apr 2004 11:19:35 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i3RGJF614183 for ; Tue, 27 Apr 2004 11:19:25 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8A84772DF20; Tue, 27 Apr 2004 10:47:27 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 32212-82; Tue, 27 Apr 2004 10:47:27 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F1B0472F758; Tue, 27 Apr 2004 10:37:41 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 27 Apr 2004 10:36:05 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C277C72E43E for ; Tue, 27 Apr 2004 10:21:58 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25593-18 for ; Tue, 27 Apr 2004 10:21:58 -0500 (EST) Received: from hotmail.com (bay18-dav22.bay18.hotmail.com [65.54.187.202]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DEE3F72EF6E for ; Tue, 27 Apr 2004 10:19:26 -0500 (EST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 27 Apr 2004 08:31:59 -0700 Received: from 62.3.32.35 by bay18-dav22.bay18.hotmail.com with DAV; Tue, 27 Apr 2004 15:31:59 +0000 X-Originating-IP: [62.3.32.35] X-Originating-Email: [sjaffarhussain@hotmail.com] X-Sender: sjaffarhussain@hotmail.com From: "syed jaffar hussain" To: Subject: latches Date: Tue, 27 Apr 2004 18:29:27 +0300 Message-ID: <006501c42c6c$6d0dd650$840a010a@app02test> MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 Importance: Normal In-Reply-To: <20040427134905.GE18789@mladen.wangtrading.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-OriginalArrivalTime: 27 Apr 2004 15:31:59.0507 (UTC) FILETIME=[C7E65E30:01C42C6C] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 3862 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: sjaffarhussain@hotmail.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hello List, We have ePayment system and we use TIBCO application. An adaptor has a update sql statements that runs continuously. I found the following top 5 waits events for this session Log file sysn(redo allocation retries + Avergae redo wirte size = are very high) Latch free (Cache buffers chains + Library cache) I know that latch free(cache buffers chains) accessing the same block/buffers again & again. How can I avoid hot block/buffers problem? Best Regards, Syed Jaffar Hussain ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------