Re: AWR interpretation
From: Andy Klock <andy_at_oracledepot.com>
Date: Fri, 1 Nov 2013 11:14:11 -0400
Message-ID: <CADo_RaMDZ7yabuSvQ8LPggUMoSZEruq-yX4cr2XzCekyczja9Q_at_mail.gmail.com>
On Fri, Nov 1, 2013 at 11:03 AM, Storey, Robert (DCSO) <RStorey_at_dcso.nashville.org> wrote:
> So if I save the commit to the end, at least this will clear up the 25K commits a minute and hopefully translate to a faster import...
>
> One could hope.
>
Date: Fri, 1 Nov 2013 11:14:11 -0400
Message-ID: <CADo_RaMDZ7yabuSvQ8LPggUMoSZEruq-yX4cr2XzCekyczja9Q_at_mail.gmail.com>
On Fri, Nov 1, 2013 at 11:03 AM, Storey, Robert (DCSO) <RStorey_at_dcso.nashville.org> wrote:
> So if I save the commit to the end, at least this will clear up the 25K commits a minute and hopefully translate to a faster import...
>
> One could hope.
>
Yes, that should help reduce the contention of the "log file sync"s (62% DB Time), though this is also indicative of slow IO for redo which you also mentioned.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 01 2013 - 16:14:11 CET