From oracle-l-bounce@freelists.org Mon Apr 12 12:23:00 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3CHMhT03706 for ; Mon, 12 Apr 2004 12:22:48 -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 i3CHMc603683 for ; Mon, 12 Apr 2004 12:22:43 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 466646348A3; Mon, 12 Apr 2004 12:16:48 -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 23417-75; Mon, 12 Apr 2004 12:16:47 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 50B496348A4; Mon, 12 Apr 2004 12:16:31 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 12 Apr 2004 12:15:14 -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 C96156347EE for ; Mon, 12 Apr 2004 12:15:13 -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 23794-22 for ; Mon, 12 Apr 2004 12:15:13 -0500 (EST) Received: from qescan1.qgraph.com (QESCAN2.qgraph.com [206.158.124.8]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1CC2A63479C for ; Mon, 12 Apr 2004 12:15:12 -0500 (EST) Received: by sxsmtp2.qgraph.com with Internet Mail Service (5.5.2657.72) id ; Mon, 12 Apr 2004 12:23:24 -0500 Message-ID: From: "Jesse, Rich" To: "ORACLE-L (E-mail)" Subject: VxFS tunables for Oracle on HP/UX Date: Mon, 12 Apr 2004 12:23:13 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-type: text/plain; charset=iso-8859-1 X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 2885 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Rich.Jesse@quadtechworld.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hey all, In implementing a SAN on a new HP/UX 11.11 system, I'm not particularly blown away by the I/O performance from Oracle or otherwise, with or without the 2GB writeback caching. So, I'm looking to see what our tunables are. One batch of tunables are the VxFS "vol_xxxx" kernel parameters. Has anyone messed with these for maximizing I/O performace for Oracle? In particular, it seems that the default value for "vol_maxio" may be inadequate for Oracle, but I haven't been able to find a definitive guide as to how to determine a proper value. The Most Venerable Gaja has some references to this in his "Implementing RAID on Oracle" whitepaper (http://www.revealnet.com/pipelines/dba/archives/Raid1.pdf), but the calculation of the value of vol_maxio is a little vague, suggesting either 2048 or 8192, but not being definitive as to how to determine which is "better" (pages 16-17 of the whitepaper). I also found an HP-UX guide to the "vol_xxxx" parameters at docs.hp.com, but there are no suggested values for vol_maxio and most other params. One thing it does say is that "The value of voliomem_maxpool_sz must be at least 10 times greater than the value of vol_maxio." But since the UOMs are different between the two params -- vol_maxio is in 512-byte blocks and voliomem_maxpool_sz is in bytes -- it doesn't say if the specified value is to be 10 times greater or if it's the number of bytes that's supposed to be 10x. I need to keep in mind that VxFS is used both for DBs on the SAN as well as software and other files on the local SCSI drives. I imagine that the DB I/O performance would be more important, though. Thoughts, anyone? Rich Rich Jesse System/Database Administrator rich.jesse@quadtechworld.com QuadTech, Sussex, WI USA ---------------------------------------------------------------- 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 -----------------------------------------------------------------