Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> REPOST: Re: Async I/O is NOT supppressed for filesystem datafiles in 8.1.5?
Can you clarify your problem:
You say
>You're misunderstanding. I'm very well versed in >the difference between kernel aio and filesystem >aio on Solaris. In my case, DBWR is using the >latter against my datafiles.
But you also say
>So, why is my instance still trying to use it?
Are you complaining because your system IS using aync I/O, or because your system is TRYING to use Async I/O ?
A couple of ideas that may help:
Thank you for pointing out my error regarding NFS, and the NetApps, and more thanks to Paul Fagan for posting a useful URL.
-- Jonathan Lewis http://www.jlcomp.demon.co.uk Now running 3-day intensive seminars http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases El Toro wrote in message <2e1cd2b.0112280628.63eb2f9f_at_posting.google.com>...Received on Fri Dec 28 2001 - 09:19:46 CST
>You're misunderstanding. I'm very well versed in
>the difference between kernel aio and filesystem
>aio on Solaris. In my case, DBWR is using the
>latter against my datafiles.
>
>However, Oracle claims that the oracle process will
>determine whether filesystem files are in use, and
>if so will turn OFF disk_asynch_io -- even if you
>have it set to true (check Metalink DocID 214480.999
>for details).
>
>So, why is my instance still trying to use it?
>
>
>Martin Haltmayer <Martin.Haltmayer_at_d2mail.de> wrote in message
news:<3C2C4693.B6D70062_at_d2mail.de>...
>> Please show the truss output. Oracle by itself does not prevent kaio
calls. But
>> in Solaris they return with an ENOTSUP exception and Oracle reverts to
>> pwrite/pread calls. So Oracle tries whatever you tell it in init.ora. If
you put
>> disk_asynch_io = true there it will try kaio calls. If they fail it will
go back
>> to pread/pwrite.
>>
>> On Solaris it is safe to request kaio on filesystems but it is slow
because you
>> add the overhead of exception handling *after each kaio call*.
>>
>> Regards,
>>
>> Martin
========= WAS CANCELLED BY =======: Path: news.sol.net!spool0-nwblwi.newsops.execpc.com!newsfeeds.sol.net!priapus.visi.com!news-out.visi.com!hermes.visi.com!newsxfer.visi.net!newsfeed.direct.ca!look.ca!newsfeed1.earthlink.net!newsfeed.earthlink.net!uunet!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r From: "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server Subject: cmsg cancel <1009552680.15046.0.nnrp-14.9e984b29_at_news.demon.co.uk> Control: cancel <1009552680.15046.0.nnrp-14.9e984b29_at_news.demon.co.uk> Date: Mon, 31 Dec 2001 07:21:31 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.1009552680.15046.0.nnrp-14.9e984b29_at_news.demon.co.uk> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009790083 28060 166.102.15.34 (31 Dec 2001 09:14:43 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 31 Dec 2001 09:14:43 GMT X-No-Archive: yes Comment: Anarchy! Fuck You! X-Commentary: I love NewsAgent 1.10, Sandblaster Build 74 (19 March 1999) and the Polaris Cancel Engine V. 6.1 X-Unacanc3l: yes This message was cancelled from within Mozilla...not