RE: linux Async io

  • From: "Hsieh, Joan" <Joan.Hsieh@xxxxxxxxx>
  • To: David Barbour <david.barbour1@xxxxxxxxx>
  • Date: Fri, 22 Mar 2013 18:26:17 +0000

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

Other related posts:

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