Re: linux Async io

It appears it is - but may not be very efficient at this point. What version of Oracle and Linux are you using? What type of filesystem/disk/etc. (Not just NetApps - ASM, OCFS, etc.)?

On Fri, Mar 22, 2013 at 11:47 AM, Hsieh, Joan <Joan.Hsieh_at_tufts.edu> wrote:
> 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
>
>

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