From oracle-l-bounce@freelists.org Thu Nov 25 14:29:41 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iAPKTf003659 for ; Thu, 25 Nov 2004 14:29:41 -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 iAPKTfx03654 for ; Thu, 25 Nov 2004 14:29:41 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 99E1D72C3C4; Thu, 25 Nov 2004 15:36:01 -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 13040-90; Thu, 25 Nov 2004 15:36:01 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9E01F72C116; Thu, 25 Nov 2004 15:35:53 -0500 (EST) Date: Thu, 25 Nov 2004 20:34:02 +0000 From: Mladen Gogala Subject: Re: Viewing filesystemio options To: oracle-l References: <200411252120.27300.uwe.weber@teleos-web.de> In-Reply-To: <200411252120.27300.uwe.weber@teleos-web.de> (from uwe.weber@teleos-web.de on Thu Nov 25 15:20:27 2004) Message-Id: <1101414842l.7088l.1l@medo.noip.com> MIME-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit X-archive-position: 12803 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: gogala@sbcglobal.net Precedence: normal Reply-To: gogala@sbcglobal.net X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Comments inline. On 11/25/2004 03:20:27 PM, Uwe Weber wrote: > Hello list, >=20 > Is there are way to see through oracle itself > which filesystemio_options it is really using, > if the parameter is set to 'setall'. Something > that shows me which options are used when > opening a file? The only way is to use truss, strace or tusc, depending on the =20 platform. What you want to see is the presence of O_NONBLOCK (O_NDELAY)=20 and O_DIRECT flags. >=20 > And to those who know JFS2: I have trussed a > session, it opened a file with asynch_nowait, is > that what you would expect from a filesystem > mounted cio? Filesystem mounted your chief information officer and he or she did not complain? Just kidding. As far as I am aware, Oracle has no special =20 option enabling it to use "concurrent I/O". That is the same feature =20 that was available years ago in XFS, allowing "guaranteed bandwidth" I/O, but this features are non-standard and cannot be used by database software. They can, however, be utilized by AIX itself, speeding up =20 file operations. --=20 Mladen Gogala Oracle DBA -- http://www.freelists.org/webpage/oracle-l