Re: Slower performance after enabling async io on Oracle Linux

From: joel garry <>
Date: Mon, 14 May 2012 09:17:31 -0700 (PDT)
Message-ID: <>

On May 14, 2:03 am, Matthias Hoys <> wrote:
> Hello,
> Platform is Oracle Linux 6.2 64-bit with Oracle 64-bit.
> After enabling async io, I see slower performance for data pump exports, RMAN backups and long-running queries (between 10 and 15% slower).
> I enabled async io with:
> aio-nr is 19052 and aio-max-nr is 1048576. Storage is on iSCSI.
> Anyone else with the same experience? Is extra tuning for async io possible on Oracle Linux?
> Thanks,
> Matthias Hoys

Well, it could be simply squeezing the bottleneck balloon, where something goes faster and consequently something depending on it slows down (for example, more cpu required to service more I/O). Some hugepages misconfiguration could have strange consequences simply from wasted memory, too.

Also see, for example, fixed by your patch, but the linux/oracle async interaction is so delicate, you may be seeing something unfixed by the patch. Any errors like,2 ?


-- is bogus.
Received on Mon May 14 2012 - 11:17:31 CDT

Original text of this message