Hi Steve,

That is true only. When there is more than 1MB of change records (or change
vectors)
LGWR will start writing irrespective of commit or 1/3 full.


Best Regards,
K Gopalakrishnan
Bangalore, INDIA


-----Original Message-----
From: Dirschel, Steve [mailto:Steve.[Email Address Removed] Friday, November 30, 2001 12:34 PM
To: LazyDBA.com Discussion
Subject: When does LGWR write

Could someone please settle a debate-

Is one of the conditions that will cause LGWR to write:
"when there is more than a megabyte of changed records in the redo log
buffer"?

An Oracle 8 training manual has this listed, I've never heard this before,
and the Oracle 8.1.6 documentation makes no reference to this.

Thanks


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Oracle LazyDBA home page