Re: Oracle and Veritas direct io

Hi

you may want to get the book "Oracle 8i & Unix Performance Tuning" by Alomari and read the section on Veritas and I/O on pages 140-141. The best combinations of parameters you mention depend on version, use and testing.

HTH Pete Finnigan
www.pentest-limited.com

In article <3BC1B64D.8060003_at_spray.fr>, Hieraklion <hieraklion_at_spray.fr> writes
>"Bonjour" from Paris,
>
>I have Veritas Datbase Edition with vxfs file-system on sun Sparc
>Solaris, Oracle database 816 64b, but without quick i/o.
>
>Parameters : db_block_size = 8K,
> db_file_multiblock_read_count=16K
>
>I want to use direct io.
>
>1/ How i indicate i want to use direct io, il have found two options to the
>mount option of the fs, mincache=direct and convosync=direct.
>
>2/ If i use direct io, is there parameters to modify in the init.ora ?
>Can i again put disk_async_io to TRUE or must i to put disk_async_io to
>FALSE and what about tape_async_io ?
>What about db_file_direct_io ?
>
>3/ Do you have an idea about the srtipe size for disks in my
>configuration (i suggest to put stripe size to 128K). What about a
>stripe size for the disks ?
>
>Thanks
>"Au revoir" from Paris.
>
>

-- 
Pete Finnigan
IT Security Consultant
PenTest Limited

Office  01565 830 990
Fax     01565 830 889
Mobile  07974 087 885

pete.finnigan_at_pentest-limited.com

www.pentest-limited.com