From oracle-l-bounce@freelists.org Fri Sep 3 10:00:09 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i83F08g13289 for ; Fri, 3 Sep 2004 10:00:08 -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 i83F08I13284 for ; Fri, 3 Sep 2004 10:00:08 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E7F9A72C802; Fri, 3 Sep 2004 10:02:21 -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 27215-25; Fri, 3 Sep 2004 10:02:21 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D765172C6BF; Fri, 3 Sep 2004 10:02:16 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Message-ID: <30462D80AA52E74698512ADCC4F7EAA312239737@EXCHANGE> From: "Gogala, Mladen" To: "'roger_xu@dp7uptx.com'" , oracle-l@freelists.org Subject: RE: Why "show parameter filesystemio_options" returns "asynche/PR 2/920_64/dbs/" Date: Fri, 3 Sep 2004 11:04:03 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 9103 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Mladen.Gogala@aetn.com Precedence: normal Reply-To: Mladen.Gogala@aetn.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Now I need Dan's help. I know that the latest version of UFS file system supports direct I/O, but I'm not sure which incarnation lives on Solaris9. Solaris 10 has UFS2, which does support direct I/O. If you didn't set up a parameter and the file system that your data files are residing on doesn't support direct I/O, then you're not doing it. My advice is to truss oracle during startup and see whether "open" system call uses O_DIRECT flag. You can also write a little C program which would use O_DIRECT and see how does it work and whether it reports any errors or not. -- Mladen Gogala A & E TV Network Ext. 1216 > -----Original Message----- > From: Roger Xu [mailto:roger_xu@dp7uptx.com] > Sent: Friday, September 03, 2004 10:43 AM > To: oracle-l@freelists.org > Subject: Why "show parameter filesystemio_options" returns > "asynche/PR2/920_64/dbs/" > > > I_did_not_set_this_parameter_in_my_oracle_parameter_file. > How_do_I_know_whether_it_is_using_direct_io_in_my_database? > Solaris_9_plain_ufs_and_Oracle_9.2.0.4.0 > Thanks > Roger_Xu > > This=20e-mail=20is=20intended=20solely=20for=20the=20person=20 > or=20entity=20= > to=20which=20it=20is=20addressed=20and=20may=20contain=20confi > dential=20an= > d/or=20privileged=20information.=20Any=20review,=20disseminati > on,=20copyin= > g,=20printing=20or=20other=20use=20of=20this=20e-mail=20by=20p > ersons=20or=20= > entities=20other=20than=20the=20addressee=20is=20prohibited.=2 > 0If=20you=20= > have=20received=20this=20e-mail=20in=20error,=20please=20conta > ct=20the=20s= > ender=20immediately=20and=20delete=20the=20material.=20 > ____________________________________________________________________ > This=20email=20has=20been=20scanned=20for=20all=20viruses=20by > =20the=20Mes= > sageLabs=20Email=20Security=20System.=20Any=20questions=20plea > se=20call=20= > 972-721-8257=20or=20email=20your=20request=20to=20tech_support > @dp7uptx.com= > . > -- > To unsubscribe - > mailto:oracle-l-> request@freelists.org&subject=unsubscribe > To > search the > archives - http://www.freelists.org/archives/oracle-l/ > -- To unsubscribe - mailto:oracle-l-request@freelists.org&subject=unsubscribe To search the archives - http://www.freelists.org/archives/oracle-l/