From oracle-l-bounce@freelists.org Sat Apr 24 09:37:14 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3OEauq09330 for ; Sat, 24 Apr 2004 09:37:06 -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 i3OEak609281 for ; Sat, 24 Apr 2004 09:36:56 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 926C472CC3E; Sat, 24 Apr 2004 09:29:20 -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 24391-08; Sat, 24 Apr 2004 09:29:20 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C866B72CA9F; Sat, 24 Apr 2004 09:28:39 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 24 Apr 2004 09:27:22 -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 12DC572CCCD for ; Sat, 24 Apr 2004 09:27:21 -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 22196-78 for ; Sat, 24 Apr 2004 09:27:20 -0500 (EST) Received: from hotmail.com (bay18-dav60.bay18.hotmail.com [65.54.187.240]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0598372CC7D for ; Sat, 24 Apr 2004 09:26:34 -0500 (EST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Sat, 24 Apr 2004 07:38:36 -0700 Received: from 62.3.32.34 by bay18-dav60.bay18.hotmail.com with DAV; Sat, 24 Apr 2004 14:38:36 +0000 X-Originating-IP: [62.3.32.34] X-Originating-Email: [sjaffarhussain@hotmail.com] X-Sender: sjaffarhussain@hotmail.com From: "syed jaffar hussain" To: Subject: cache buffers chains & library cache --- latch, latch again... Date: Sat, 24 Apr 2004 17:36:07 +0300 Message-ID: <000901c42a09$7abee6a0$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 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-OriginalArrivalTime: 24 Apr 2004 14:38:36.0868 (UTC) FILETIME=[D3BD3040:01C42A09] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 3717 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 Hi list, My database is up since december 2003. However, when I go through v$latch, I found the following; NAME GETS MISSES SLEEPS ------------------------------ ---------- ---------- ---------- session allocation 1197361058 152407 7480 multiblock read objects 1209057328 1532778 41137 cache buffers lru chain 2791819365 7612195 269427 ===> session idle bit 4929270638 87527 3590 library cache 6719774102 2139530 937599 ====> cache buffers chains 7.6325E+10 14700803 934118 ====> redo writing 110939333 616464 75353 messages 161204253 259719 22385 checkpoint queue latch 352667859 73646 4821 shared pool 418028301 58660 12236 row cache objects 458785060 4877123 94779 redo allocation 468537523 125368 9327 enqueues 678664061 26255 3184 And when I dig at v$latch_children I found a lot of misses for NAME GETS MISSES SLEEPS ------------------------------ ---------- ---------- ---------- library cache 1145632268 500990 289291 library cache 1864524856 524985 73132 library cache 2557348906 753180 507015 library cache 706338241 232889 41144 library cache 445934611 127500 27031 cache buffers chains 50657614 8439 492 cache buffers chains 41067021 6318 427 cache buffers chains 43140486 7272 474 cache buffers chains 44849453 6217 450 cache buffers chains 45883393 5701 407 cache buffers chains 50139764 6847 556 cache buffers chains 56838229 9668 625 cache buffers chains 52779420 10468 653 cache buffers chains 54897378 6835 466 cache buffers chains 61131696 12187 560 (hell a lot of rows found there for these two) How can I solve this problem? Is it very bad for performance point of view, having such big values for those latches? Best Regards, Syed Jaffar Hussain Sr Oracle DBA Sejel Technology Ltd. +966 2 6064971 x 324 4 ---------------------------------------------------------------- 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 -----------------------------------------------------------------