REPOST: Re: Async I/O is NOT supppressed for filesystem datafiles in 8.1.5?

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!news-out.visi.com!hermes.visi.com!uunet!ash.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r From: medawsonjr_at_yahoo.com (El Toro) Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server Subject: cmsg cancel <2e1cd2b.0112280628.63eb2f9f_at_posting.google.com> Control: cancel <2e1cd2b.0112280628.63eb2f9f_at_posting.google.com> Date: Mon, 31 Dec 2001 07:49:24 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.2e1cd2b.0112280628.63eb2f9f_at_posting.google.com> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009790095 28060 166.102.15.34 (31 Dec 2001 09:14:55 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 31 Dec 2001 09:14:55 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 Received on Fri Dec 28 2001 - 08:28:39 CST