concurrent I/O AIX 5.3

[rusty838]

We are setting up some new p570, AIX 5.3. We will be using oracle 9i. I have been asked about CIO. I would like to find out what considerations that i need.

Any information would be great

Thanks

 

[Gloups]

Have a look to this document:

http://download-east.oracle.com/docs/html/B10812_06/appendix_a.htm#i631245

This is for Oracle 10, but very close to Oracle 9

 

[7280]

Hi,
I'm using oracle 9i and oracle 10g on aix 5.2/5.3 and I have configured my filesystems to use concurrent io.
I have very good performance and I highly recommend it!!
I've read some where some oracle/ibm benchmarks and they state that cio performance are very similar to raw device.
I don't know if this is really true, but for sure performance are good.

Hope this helps.
Bye

 

[7280]

I forget one thing.
tempfiles should stay on a separate filesystem which uses dio (not cio!!).
I faced many problems with tempfiles on filesystems with concurrent io, so use direct io for these files!

 

[rusty838]

Thanks for the information.

Is it just a case of mounting the filesystem with the cio option.

Thanks

 

[7280]

Yes,
mount the temp filesystem with dio instead of cio.