RE: linux Async io

From: Hsieh, Joan <Joan.Hsieh_at_tufts.edu>
Date: Thu, 28 Mar 2013 15:19:18 +0000
Message-ID: <416FB269D9362D4AA40BE7124CA3EF9F0AAB7B54_at_SSVMEXDAG01MB02.tufts.ad.tufts.edu>

Hi all,
End up the performance issue has been solved by increasing the memory_target from 2 gb to 7 gb. The batch job running time is 40 min faster than on AIX. So it is still pointed back to buffer cache size, not OS i/o.

Thanks,

Joan

From: Michael McMullen [mailto:ganstadba_at_hotmail.com] Sent: Tuesday, March 26, 2013 1:38 PM
To: oracle-l_at_freelists.org; Hsieh, Joan Subject: RE: linux Async io

I've been using SLOB as a benchmark for all new server builds. It makes it nice, simple and repeatable so that you can work with sysadmins/storage to troubleshoot problems.
> From: Joan.Hsieh_at_tufts.edu<mailto:Joan.Hsieh_at_tufts.edu>
> To: mwf_at_rsiz.com<mailto:mwf_at_rsiz.com>; frits.hoogland_at_gmail.com<mailto:frits.hoogland_at_gmail.com>; david.barbour1_at_gmail.com<mailto:david.barbour1_at_gmail.com>
> CC: ORACLE-L_at_freelists.org<mailto:ORACLE-L_at_freelists.org>
> Subject: RE: linux Async io
> Date: Fri, 22 Mar 2013 20:00:57 +0000
>
> Thanks Mark,
>
> I'm curious the sync setting, but we are actually experiencing the performance issue, 60% of wait time is user io, db_ sequential_read is on top of it. This is a show stopper for us, and I am trying to find out the cause.
>
> Joan
>

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

Received on Thu Mar 28 2013 - 16:19:18 CET