From oracle-l-bounce@freelists.org Sun Mar 7 15:20:01 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i27LK1R13715 for ; Sun, 7 Mar 2004 15:20:01 -0600 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 i27LK1o13708 for ; Sun, 7 Mar 2004 15:20:01 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 01C4C394D40; Sun, 7 Mar 2004 16:20:04 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sun, 07 Mar 2004 16:18:37 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from www.hotsos.com (hotsos.com [209.120.206.15]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AF0D2394CF5 for ; Sun, 7 Mar 2004 16:18:32 -0500 (EST) Received: from CVMLAP02 ([208.251.46.10]) (authenticated (0 bits)) by www.hotsos.com (8.12.11/8.11.0) with ESMTP id i27LMhYu015116 for ; Sun, 7 Mar 2004 15:23:04 -0600 From: "Cary Millsap" To: Subject: RE: latching and the buffer cache Date: Sun, 7 Mar 2004 15:20:13 -0600 Message-ID: <001a01c4048a$0a282ea0$8b00470a@CVMLAP02> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001B_01C40457.BF8DBEA0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.3416 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 In-Reply-To: <019401c4046e$b5ec1c40$51a36244@ryan2le36ofjce> Importance: Normal X-archive-position: 36 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cary.millsap@hotsos.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------=_NextPart_000_001B_01C40457.BF8DBEA0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit These are kind of the right words, but in kind of the wrong order :-). Please see "Why you should focus on LIOs instead of PIOs" at www.hotsos.com/e-library for details, including pictures. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance Diagnosis 101: 3/23 Park City, 4/6 Seattle - Hotsos Symposium 2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Ryan Sent: Sunday, March 07, 2004 12:05 PM To: oracle-l@freelists.org Subject: latching and the buffer cache Does each latch chain have its own latch? Or does the DB_LRU_LATCH_CHAIN paramter determine how many total latches there are in the buffer cache? ------=_NextPart_000_001B_01C40457.BF8DBEA0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

These are kind of the right words, = but in kind of the wrong order J.

Please see “Why you should = focus on LIOs instead of PIOs” at www.hotsos.com/e-library for details, including pictures.

Cary = Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Nullius in = verba

Upcoming events:
- Performance Diagnosis 101: 3/23 Park City, 4/6 Seattle
- Hotsos = Symposium 2004: March 7–10 Dallas
- Visit www.hotsos.com for = schedule details...

-----Original = Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] = On Behalf Of Ryan
Sent: Sunday, March 07, = 2004 12:05 PM
To: oracle-l@freelists.org
Subject: latching and the = buffer cache

Does each latch chain have = its own latch? Or does the DB_LRU_LATCH_CHAIN paramter determine how many total = latches there are in the buffer cache?

------=_NextPart_000_001B_01C40457.BF8DBEA0-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------