linux Async io

From: Hsieh, Joan <Joan.Hsieh_at_tufts.edu>
Date: Fri, 22 Mar 2013 16:47:03 +0000
Message-ID: <416FB269D9362D4AA40BE7124CA3EF9F0AAAC2AA_at_SSVMEXDAG01MB02.tufts.ad.tufts.edu>

Hi,
We are migrating DW database from AIX to linux, the online transaction is ok compared to AIX. But the batch job is 35% slower than AIX. Of course, the architecture are different, the storage is Netapps on Linux. From the awa report. 60% time is user IO waiting. I'm not sure how to read the following information, is it async io enabled?

Thank,

Joan

dwdb-prod-01:c0ra1e)SDWPRD:/oracle/product/11.2.0.3/bin> cat /proc/slabinfo | grep kio

kioctx                56     80    384   10    1 : tunables   54   27    8 : slabdata      8      8      0
kiocb                  0      0    256   15    1 : tunables  120   60    8 : slabdata      0      0      0

dwdb-prod-01:c0ra1e)SDWPRD:/oracle/product/11.2.0.3/

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 22 2013 - 17:47:03 CET