Re: log file sync
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 13 Oct 2006 14:33:23 +0100
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"
Regards
Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
----- Original Message -----
From: <oracle@xxxxxxxxxxxx>
To: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
Cc: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>;
<oracle-l@xxxxxxxxxxxxx>
Sent: Friday, October 13, 2006 2:12 PM
Subject: Re: log file sync
On Thu, 12 Oct 2006, Alex Gorbachev wrote:
Maybe I missed something but, perhaps, you are not scoping your data
properly in time and/or sessions. If you don't have many XCTENDs than
you shouldn't have many log file sync waits either.
You said "once the big chunk of processing starts...". In this case I
assume that this chunk is your business critical part you are keen to
optimize. Thus, you should limit analysis only to this part.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
