RE: Log File Syncs

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 30 Mar 2016 11:05:56 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D9282CC1B3_at_EXMBX01.thus.corp>

See Timur's most recent reply - a glance through v$event_histogram for the two events, or checking the Wait Event Histogram section of the AWR/Statspack report, might show you some interesting skew in the wait times.

Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
_at_jloracle

---

From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Osborne, Chris [Chris.Osborne_at_sky.uk] Sent: 30 March 2016 10:49
To: JC1706_at_att.com; mwf_at_rsiz.com; gogala.mladen_at_gmail.com; oracle-l_at_freelists.org Subject: RE: Log File Syncs

Hi Jon,

Thanks for that. I was aware of most of that and I�m not sure it�s a scheduling thing.

They key thing I�m still confused about is how the average log file sync time can be LESS than the log file parallel write time.

The *real* problem is actually fixed for the moment, as the process for the load has been changed on my recommendation and no longer commits after every row. Now I�m just interested out of curiosity.

Christopher Osborne

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

Received on Wed Mar 30 2016 - 13:05:56 CEST