From oracle-l-bounce@freelists.org Fri May 28 15:58:46 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i4SKwVW02462 for ; Fri, 28 May 2004 15:58:41 -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 i4SKwL602448 for ; Fri, 28 May 2004 15:58:31 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AAA1372C33A; Fri, 28 May 2004 15:45:45 -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 20101-39; Fri, 28 May 2004 15:45:45 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 31DAA72C310; Fri, 28 May 2004 15:45:43 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 28 May 2004 15:44:17 -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 07ECF72C0A9 for ; Fri, 28 May 2004 15:44:17 -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 18899-81 for ; Fri, 28 May 2004 15:44:16 -0500 (EST) Received: from smtp-out4.xs4all.nl (smtp-out4.xs4all.nl [194.109.24.5]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 46B4372C095 for ; Fri, 28 May 2004 15:44:16 -0500 (EST) Received: from dbalert99a.xs4all.nl (dbalert.xs4all.nl [213.84.185.230]) by smtp-out4.xs4all.nl (8.12.10/8.12.10) with ESMTP id i4SL1e5a030627 for ; Fri, 28 May 2004 23:01:45 +0200 (CEST) Message-Id: <6.0.1.1.0.20040528225413.44d487b0@pop.xs4all.nl> X-Sender: (Unverified) X-Mailer: QUALCOMM Windows Eudora Version 6.0.1.1 Date: Fri, 28 May 2004 23:01:05 +0200 To: oracle-l@freelists.org From: Carel-Jan Engel Subject: Re: Filesystem vs. Raw IO In-Reply-To: <40B74730.8080401@optusnet.com.au> References: <40B7311E.7080208@optusnet.com.au> <20040528130012.GA2039@mladen.wangtrading.com> <40B74730.8080401@optusnet.com.au> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=====================_2488262==.ALT" X-Virus-Scanned: by amavisd-new at freelists.org 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: cjpengel.dbalert@xs4all.nl Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org --=====================_2488262==.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed IBM claims they can reach nearly RAW-partition performance on filesystems using concurrent IO supported by JFS2. Some figures (from the paper http://unix.ittoolbox.com/browse.asp?c=UNIXPeerPublishing&r=http%3A%2F%2Fwww%2D1%2Eibm%2Ecom%2Fservers%2Faix%2Fwhitepapers%2Fdb%5Fperf%5Faix%2Epdf): avg Trougput (tps) Raw LV's : Direct I/O : Concurrent I/O = 710.19 : 219.69 : 652.12. avg Response Time (sec) Raw LV's : Direct I/O : Concurrent I/O = 0.06 : 0.12 : 0.07 They did the test with 9i. The paper also discusses the use of filesystems in database environments. I hope to be able to perform some tests this year. I'm curious how this will compare with ASM in 10g. Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === --=====================_2488262==.ALT Content-Type: text/html; charset="us-ascii" IBM claims they can reach nearly RAW-partition performance on filesystems using concurrent IO supported by JFS2. Some figures (from the paper http://unix.ittoolbox.com/browse.asp?c=UNIXPeerPublishing&r=http%3A%2F%2Fwww%2D1%2Eibm%2Ecom%2Fservers%2Faix%2Fwhitepapers%2Fdb%5Fperf%5Faix%2Epdf):

avg Trougput (tps) Raw LV's : Direct I/O : Concurrent I/O = 710.19 : 219.69 : 652.12.
avg Response Time (sec) Raw LV's : Direct I/O : Concurrent I/O = 0.06 : 0.12 : 0.07

They did the test with 9i. The paper also discusses the use of filesystems in database environments.

I hope to be able to perform some tests this year. I'm curious how this will compare with ASM in 10g.

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok)
===

 --=====================_2488262==.ALT-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------