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

"Bonjour" from Paris

Async IO on fs = OK on sun Sparc Solaris (see the different file system types on Sun : native, Vxfs ...)

"Au revoir" from Paris
Hieraklion

koert54 wrote:

>I know of only one OS that supports ASYNC I/O on JFS and that's IBM AIX.
>If you want ASYNC I/O on other operating systems my guess is you'll have to
>use
>raw devices ...
>
>
>
>"El Toro" <medawsonjr_at_yahoo.com> wrote in message
>news:2e1cd2b.0112272350.11c9fb47_at_posting.google.com...
>
>>I've read both Metalink and Sun Blueprint documents that read
>>how Oracle 8.1.5 and 8.1.6 will NOT use AIO on filesystem datafiles.
>>It runs 'fstat()' to determine if the files are on filesystems, and
>>acts accordingly (according to Oracle and Sun). Therefore, turning
>>AIO on via 'disk_asynch_io=true' on such databases is futile, based
>>on these two sources.
>>
>>However, I have 8.1.5 running on NFS *filesystems* from NetApps, and
>>they are, in fact, using AIO. I've verified this by running a 'truss'
>>on the DBWR process, noticing all the LWP processes spawned to perform
>>the user-level library AIO after a failed 'kaio()' call (tell-tale
>>signs of AIO). The OS is Solaris 2.6 - 2.8, by the way.
>>
>>So, what's the deal? Does Oracle 8.1.5 and .6 use AIO on filesystems
>>or not? When is it that Oracle suppresses AIO on filesystems? I gotta
>>save face here in front of my team members to whom I insisted that
>>Oracle did away with filesystem AIO on filesystems. Please respond
>>quickly, as I have a team meeting about this issue tomorrow.
>>
>>Thanks in advance.
>>
>
>========= 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: "koert54" <koert54_at_nospam.com>
>Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server
>Subject: cmsg cancel <02XW7.1339$%x2.209345654_at_hestia.telenet-ops.be>
>Control: cancel <02XW7.1339$%x2.209345654_at_hestia.telenet-ops.be>
>Date: Mon, 31 Dec 2001 05:53:19 GMT
>Organization: Navix Internet Subscribers
>Lines: 2
>Message-ID: <cancel.02XW7.1339$%x2.209345654_at_hestia.telenet-ops.be>
>NNTP-Posting-Host: 166.102.15.34
>X-Trace: iac5.navix.net 1009790238 28060 166.102.15.34 (31 Dec 2001 09:17:18 GMT)
>X-Complaints-To: abuse_at_navix.net
>NNTP-Posting-Date: 31 Dec 2001 09:17:18 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 Wed Jan 02 2002 - 05:20:08 CST