RE: linux Async io

Thanks, our oracle is 11.2.0.3 both on AIX and Linux are the same .

Aix : 6.0

Linux :
Red Hat Enterprise Linux Server release 6.3 (Santiago) Red Hat Enterprise Linux Server release 6.3 (Santiago)

Filesysem is NFS on netapps, direct NFS enabled.

vftss-gpdata-01-stor.uit.tufts.edu:/vol/dw_prod_sdw01/dw_prod_sdw01

                     209715200  53072512 156642688  26% /SDWPRD

Thanks,

joan
-----Original Message-----
From: David Barbour [mailto:david.barbour1_at_gmail.com] Sent: Friday, March 22, 2013 1:54 PM
To: Hsieh, Joan
Cc: oracle_l
Subject: Re: linux Async io

Joan,

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