Re: log file sync

From: Mladen Gogala <mgogala_at_verizon.net>
Date: Fri, 13 Oct 2006 18:30:28 -0400
Message-id: <1160778628l.2768l.4l@medo.noip.com>

On 10/13/2006 09:33:23 AM, Jonathan Lewis wrote:
>
> There are various types of recursive activity
> that could result in log file sync. For example,
> leaf block splits, and other activity relating to
> massive restructuring of indexes
>
> Check the session stats for
> "leaf node splits"
> and "transaction rollbacks"
>

Jonathan, Christian Antognini said that he has never seen log file sync event without a commit. Does that mean that leaf node split entails a commit or that Christian is wrong?

-- 
Mladen Gogala
http://www.mladen-gogala.com

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

Received on Fri Oct 13 2006 - 17:30:28 CDT