Re: linux Async io

  • From: Frits Hoogland <frits.hoogland@xxxxxxxxx>
  • To: "david.barbour1@xxxxxxxxx" <david.barbour1@xxxxxxxxx>
  • Date: Fri, 22 Mar 2013 19:06:49 +0100

A sane beginning would be to start with source platform and version and
hardware layout en destination specifications. And parameters of both
instances.
Then look at both (source and destionation) execution plans.

Then run the critical sql's on both platforms with SQL trace at level 8,
and compare them.

Frits Hoogland

http://fritshoogland.wordpress.com
frits.hoogland@xxxxxxxxx
+31 6 53569942 <+31%206%2053569942>

Op 22 mrt. 2013 om 18:55 heeft David Barbour <david.barbour1@xxxxxxxxx> het
volgende geschreven:

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