Concurrent I/O (AIX 5.2)

  • From: "Stuart Clowes" <stuart.clowes@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 28 Jun 2006 21:06:43 +0100

We bit the bullet and implemented concurrent I/O (AIX 5.2 ML6,,
JFS2, ESS storage).

It seemed to make operations doing table scans slower (exports in particular
took 50% longer). We have 8K block size, DB_FILE_MULTIBLOCK_READ_COUNT=8. I
suspect that not having the benefit of JFS2 readahead may be hurting us

There was no noticable difference on operations performing random IO.

We did this because of a perceived problem with I/O (intermittent periods of
high wait I/O with apparently low actual physical I/O; variations in
response time of standard queries, even at apparently 'quiet' times). An IBM
guru told us that the wait I/O may be due to the stresses of managing page
replacement in the JFS2 cache, rather than problems at the disk layer.
Howerver, moving to CIO made no obvious difference to our wait I/O or disk

I'd be interested in the experiences of others who have moved from JFS2
cached I/O to concurrent I/O. Did you have a positve, negative, or mixed

Other related posts: