RE: linux Async io

From: CRISLER, JON A <JC1706_at_att.com>
Date: Fri, 22 Mar 2013 18:52:19 +0000
Message-ID: <9F15274DDC89C24387BE933E68BE3FD3082E3ED0_at_MISOUT7MSGUSR9D.ITServices.sbc.com>

Look at the NFS network path- what speed and connections are you running ? Was it the same NFS on AIX ? For comparision- 1gb ethernet for NFS will be significantly slower than 4gb Fiber Channel. 10gb Ethernet for NFS will be somewhat faster than 4gb Fiber channel, while 8gb FC and 10gb enet NFS are similar. Also, do you have jumbo frames set up for the NFS link ?

You could try running Orion on both systems to get a direct comparision.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hsieh, Joan Sent: Friday, March 22, 2013 2:26 PM
To: David Barbour
Cc: oracle_l
Subject: RE: linux Async io

Hi David,

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


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

Received on Fri Mar 22 2013 - 19:52:19 CET