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

Home -> Community -> Mailing Lists -> Oracle-L -> Was 10G and UFS - long write times (is, I/O really?)

Was 10G and UFS - long write times (is, I/O really?)

From: Kevin Closson <kevinc_at_polyserve.com>
Date: Thu, 8 Jun 2006 09:49:02 -0700
Message-ID: <5D2570CAFC98974F9B6A759D1C74BAD0E5A729@ex2.ms.polyserve.com>

        PS the waits are all IO related - log buffer , log file sync etc

... are you absolutely sure the I/O component of these waits is what is actually slow.
You know there is more to the anatomy of a log file sync and log buffer wait than
I/O right? A process get posted though the post/wait mechanism (port dependent)
and THEN it comes out of the wait. In short, there is IPC wrapped around the LGWR
loop. I wonder if there is something in the 10gR2 post/wait driver that is busted?
Quite possible. How do they compare with _logging_disable=TRUE? When this is set there
is still LGWR posting and lfs waits, but LGWR doesn't actually write to the log.

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 08 2006 - 11:49:02 CDT

Original text of this message

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