Isn't the giveaway here the 'NFS'.
You are not supposed to run Oracle to
NFS mounted files. At least it used to
be the case that the documentation
stated explicitly that using Oracle on
NFS was not supported.
--
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
El Toro wrote in message <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!spool1-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: "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk>
Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server
Subject: cmsg cancel <1009535229.11087.0.nnrp-10.9e984b29_at_news.demon.co.uk>
Control: cancel <1009535229.11087.0.nnrp-10.9e984b29_at_news.demon.co.uk>
Date: Mon, 31 Dec 2001 06:32:12 GMT
Organization: Navix Internet Subscribers
Lines: 2
Message-ID: <cancel.1009535229.11087.0.nnrp-10.9e984b29_at_news.demon.co.uk>
NNTP-Posting-Host: 166.102.15.34
X-Trace: iac5.navix.net 1009790154 28060 166.102.15.34 (31 Dec 2001 09:15:54 GMT)
X-Complaints-To: abuse_at_navix.net
NNTP-Posting-Date: 31 Dec 2001 09:15:54 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 - 04:25:45 CST
