Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

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

Kevin Closson

2006-06-08


>>>
>>>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.

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


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.