Skip to main content



Database server

developerWorks

General DB2 Informix Oracle
   Recommendations  |   Performance papers

Initialization parameters used for Oracle I/O option measurements
Miscellaneous settings
Selecting the test scenario
I/O options
Relink Oracle for async I/O

I/O Options

Oracle 10g - I/O options, FCP/SCSI disks


The use of async I/O improves the throughput in any case. When using a file system the good result from async I/O can be further improved in combination with direct I/O (setall).

The file system ext3 (I/O option 'setall ext3') has the same performance as ext2 (I/O option 'setall') for this workload.

For disk I/O setup optimization, see Disk I/O.

 

Test environment
  • IBM eServer zSeries 900 (2064-216)
  • LPAR with 12 CPUs, 8GB memory
  • Novell/SUSE SLES 9 + SP1 for IBM zSeries (64-bit), kernel 2.6.5-7.151
  • Oracle 10g (10.1.0.3.0, 64-bit)
  • Benchmark Oracle OLTP
  • Database data Logical Volume (LV): 4 CHPIDs, 4 host adapters, FCP/SCSI, ext2/etx3 filesystem or raw devices

Back to top



Team
Please address any comments to the performance team: linux390@de.ibm.com