Re: async I/O

not familiar with this port ( HPUX ) but try async_write = FALSE

( you might check to see what's it's set to now)

and

if you're not going to async, set db_writers = < number of independent spindles for a "given" query >

    ( sorry, due to vagaries of how folks lay disk out, this will vary from 1 to the number of disks online.)

However, async is very nice. Why not set it up in the OS properly, and make use of it? Even better, if
you're on raw, check into LIST_IO which I believe is still available in 8.0.4....

hth ymmv imho, et cetera, ad nauseam.....

kennethleung_at_hotmail.com wrote in message <74j1eq$i2v$1_at_nnrp1.dejanews.com>...
>Hi all,
>
>I have just installed Oracle 8.0.4 in my HP/UX 10.20 machine.
>There are so many trace files (.trc) written in the $ORACLE_HOME/rdbms/log
>directory. They are all complaining that the "/dev/async" file.
>
>I have checked the system and there is no such file. I suspect it is
>something related to async I/O feature. Then I set both parameters
>"disk_asynch_io" and "tape_asynch_io" to FALSE. However the files still
>come out. Would any one please help me?
>
>Thanks in advance!!
>
>Kenneth
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sat Dec 12 1998 - 21:37:16 CST