Re: Async I/O

If the database is not using async i/o and its set in your init<sid>.ora then I believe you should get a message in trace files (thats my experience - raw filesystem but no /dev/async file)

Regards

Alex

opus wrote:

> Hi David, and thanks for responding ....
>
> So it doesn't work at all or would I get some sorta error message or
> it (as in the next reply) a matter of ensuring data integrity
> and that could be a potential problem. So far, I've had no
> problem but then... There's no way we're going to 11.0 anytime
> soon I doubt. So you recommend turning it off period then? Will
> I see some preformance degredation in disk writes or nothing
> as it doesn't really work?
>
> thanks again....
>
> David Lai wrote:
> >
> > JFS is the name for VERITAS File System (VxFS) on HP. Indeed it
> > does not support async I/O on 10.20. So you should not be using
> > async I/O right now. In a few month we are releasing
> > the VERITAS Storage Edition for Oracle on 11.0. This product
> > includes VxFS 3.3 that allows async I/O on files (with the VERITAS
> > Quick I/O driver). As a matter of fact, these Quick I/O files behave
> > and perform just like raw devices. On Solaris we have seen over 100%
> > performance improvements over traditional cooked files for TPCC
> > type workloads. We expect the same on HP as well.
> >
> > -- David Lai
> > VERITAS Software
> >
> > opus wrote:
> >
> > > Hello all,
> > >
> > > I'm running 7.3.4 on HP 10.20 and I've enabled async I/O in the kernel
> > > and in the init file. someone in Oracle support said to do that many
> > > moons ago even though it says only use async i/o with raw device files.
> > > I use JFS files. Now someone else from Oracle support sends me FAQ
> > > saying I shouldn't use asyn I/O with JFS but there's no reason as to
> > > what can happen if you do. So far been running like this for quite
> > > awhile. Any thoughts?
> > >
> > > I've also been running an Oracle 8.0.3 instance using async i/o (it
> > > defaults to that outta the box fer gawd's sake - all ya gotta do is set
> > > it up in Unix) for awhile as well.
> > >
> > > Reply to the newsgroup please, and thanks if anyone knows..
> > >
Received on Tue Mar 23 1999 - 02:26:18 CST