RE: linux Async io

  • From: "CRISLER, JON A" <JC1706@xxxxxxx>
  • To: "Joan.Hsieh@xxxxxxxxx" <Joan.Hsieh@xxxxxxxxx>, David Barbour <david.barbour1@xxxxxxxxx>
  • Date: Fri, 22 Mar 2013 18:52:19 +0000

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxx] 
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@xxxxxxxxx> 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/
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l


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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2013