Re: "log file parallel write" wait times get increased a lot after upgrading from 10203 to 10204
- From: Eagle Fan <eagle.f@xxxxxxxxx>
- To: Marcin Przepiorowski <pioro1@xxxxxxxxx>
- Date: Thu, 2 Dec 2010 09:49:51 +0800
hi:
Log file sync events stayed at the same level after upgrade.
Thanks.
On Thu, Dec 2, 2010 at 7:07 AM, Marcin Przepiorowski <pioro1@xxxxxxxxx>wrote:
> On Wed, Dec 1, 2010 at 12:31 AM, Tanel Poder <tanel@xxxxxxxxxx> wrote:
> > It's more likely that you hit an instrumentation bug which didn't record
> any
> > log file parallel write wait events (in most cases) in 10.2.0.3 and the
> bug
> > was fixed in 10.2.0.4. I don't know the bug# but I've seen the same
> issue,
> > also for db file parallel writes.
> > So you're not waiting more, you just know about this waiting now. Having
> > only 1193 log file parallel writes per day in a busy system doesn't sound
> > correct anyway...
>
> Hi,
>
> What about log file sync events ? Are they on this same level ?
> If yes this is another proof of Tanel theory.
>
> I have seen that bug on 9.2.0.8 AIX - lot of log file sync and only a
> few log file parallel writes.
>
> regards,
>
> --
> Marcin Przepiorowski
> http://oracleprof.blogspot.com
>
--
Eagle Fan (www.dbafan.com)
Other related posts:
