direct I/O on Hp-ux
This is a discussion on direct I/O on Hp-ux within the Oracle Database forums, part of the Database Server Software category; --> Hi, i've read some info on "filesystemio_options" here: http://download-west.oracle.com/docs...23_os.htm#4341 i would like to know if is possible to set ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 07:31 AM
| ||||
| ||||
 direct I/O on Hp-ux Hi, i've read some info on "filesystemio_options" here: http://download-west.oracle.com/docs...23_os.htm#4341 i would like to know if is possible to set Direct I/O for parameter "filesystemio_options" on hp-ux Someone have experience whit it? thanks by andrea      |
|
02-26-2008, 07:31 AM
| |||
| |||
| Re: direct I/O on Hp-ux On 7 Aug, 09:52, Andrea <netsecur...@tiscali.it> wrote: > Hi, > i've read some info on "filesystemio_options" here:http://download-west.oracle.com/docs...r.101/b10752/c... > > i would like to know if is possible to set Direct I/O for parameter > "filesystemio_options" on hp-ux > > Someone have experience whit it? > > thanks > by > andrea To enable direct IO on HPUX you need to set certain vxvfs mount options: mincache=direct covosync=direct. See http://www.oracle.com/technology/dep...e_HP_files.pdf for more info. on this topic |
|
02-26-2008, 07:31 AM
| |||
| |||
| Re: direct I/O on Hp-ux On 7 Ago, 13:45, hacketta...@mac.com wrote: > On 7 Aug, 09:52, Andrea <netsecur...@tiscali.it> wrote: > > > Hi, > > i've read some info on "filesystemio_options" here:http://download-west.oracle.com/docs...r.101/b10752/c... > > > i would like to know if is possible to set Direct I/O for parameter > > "filesystemio_options" on hp-ux > > > Someone have experience whit it? > > > thanks > > by > > andrea > > To enable direct IO on HPUX you need to set certain vxvfs mount > options: mincache=direct covosync=direct. > > Seehttp://www.oracle.com/technology/deploy/performance/pdf/TWP_Oracle_HP... > for more info. on this topic thanks very much! So, you can have experience if this option can really improve performance on OLTP db?? there is some advise for implementing direct IO rather then RawDevice ? thanks |
|
02-26-2008, 07:32 AM
| |||
| |||
| Re: direct I/O on Hp-ux On Aug 7, 2:20 pm, Andrea <netsecur...@tiscali.it> wrote: > On 7 Ago, 13:45, hacketta...@mac.com wrote: > > > > > > > On 7 Aug, 09:52, Andrea <netsecur...@tiscali.it> wrote: > > > > Hi, > > > i've read some info on "filesystemio_options" here:http://download-west.oracle.com/docs...r.101/b10752/c... > > > > i would like to know if is possible to set Direct I/O for parameter > > > "filesystemio_options" on hp-ux > > > > Someone have experience whit it? > > > > thanks > > > by > > > andrea > > > To enable direct IO on HPUX you need to set certain vxvfs mount > > options: mincache=direct covosync=direct. > > > Seehttp://www.oracle.com/technology/deploy/performance/pdf/TWP_Oracle_HP... > > for more info. on this topic > > thanks very much! > > So, you can have experience if this option can really improve > performance on OLTP db?? > there is some advise for implementing direct IO rather then > RawDevice ? > > thanks- Hide quoted text - > > - Show quoted text - You need to differentiate between direct IO (which means bypassing the file system cache) and asynchronous I/O on RAW devices and similar. The biggest performance gains are obtained using RAW. There are HP whitepapers demonstrating this. -- Sybrand Bakker Senior Oracle DBA |
|
02-26-2008, 07:35 AM
| ||||
| ||||
| Re: direct I/O on Hp-ux > > So, you can have experience if this option can really improve > performance on OLTP db?? > - Show quoted text - All the HPUX databases I manage use raw devices so I've never had to enable direct IO on a VxFS filesystem. Therefore I cannot speak from personal experience... |
Linear Mode
