From oracle-l-bounce@freelists.org Fri Jun 24 11:40:04 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j5OGe4Fl015971 for ; Fri, 24 Jun 2005 11:40:04 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180] (may be forged)) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j5OGe3Ni015967 for ; Fri, 24 Jun 2005 11:40:03 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6D43A1C476D; Fri, 24 Jun 2005 10:36:36 -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 20768-07; Fri, 24 Jun 2005 10:36:36 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E60AD1C468D; Fri, 24 Jun 2005 10:36:35 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: Q: Filesystem choice for log_archive_dest Date: Fri, 24 Jun 2005 08:34:48 -0700 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Q: Filesystem choice for log_archive_dest Thread-Index: AcV4m2AWMy4yaEaPQDS87LuoRzikzQANpUTQ From: "Kevin Closson" To: X-archive-position: 21667 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: kevinc@polyserve.com Precedence: normal Reply-To: kevinc@polyserve.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.9 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 > >Just trying to estimate the speed of writing from Oracle >instance to different filesystems. > >1. select * from table with 108127 records, I'm afraid you've got me confused. You are selecting all the rows from a little table to ascertain disk write throughput? This would be a good ettest to compare different network configs, maybe, but is an apples to bicycles comparison with regard to archive log spooling. Of course a SELECT * from a small table cached in the OS pagecache is going to be exponentially faster than physical disk reads. We need to get beyond that comparison. Memory is indeed faster than magnetic media -- http://www.freelists.org/webpage/oracle-l