RE: Was 10G and UFS - long write times (is, I/O really?)
- From: "Kevin Closson" <kevinc@xxxxxxxxxxxxx>
- To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 8 Jun 2006 13:45:49 -0700
>>>
>>>Kevin, I am not sure what your email is answering (I am
>>>missing the quoted question) but wouldn't it be better in
>>>10g to test with "commit batch nowait" rather then turning
>>>of logging with the underscore parameter ?
... if you want to totally rule out the cost of LGWR physical I/O
you have to set _disable_logging=TRUE. This is most concise way
of putting blame on the actual LGWR I/O component of some
foreground log file sync. All the other code involved with
a LFS is still executed.
Don't do this with a database you really care about, and only
do shutdown normal of course.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
