Re: async i/o via nfs?

On Tue, 5 Aug 2003 11:34:10 +0200, "Volker Hetzer" <volker.hetzer_at_ieee.org> wrote:

>The problem is
>that one of my controlfile copies and one of my archivelog copies
>sits on another machine that is mounted via nfs.

Shudder. How on earth did you decide to locate one of your controlfile copies on a nfs-mounted drive? Why not all of them? nfs is a can of worms, it is slow, it is undependable, and Oracle advises expressly against using it. I would try to use async i/o if I was looking for a different job in the near future, but not in other circumstances. Try it, and follow the results by means of truss My bet is your async i/o will fail and Oracle will resort to normal file i/o anyway. Though not once, but for every individual request. Also, if Linux uses ufs (unix file system) async i/o won't work anyway.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Aug 05 2003 - 05:57:14 CDT