Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: log file sync

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US