My vote: Yes, that is one of the conditions, along with redo log buffer is
more than 1/3 full.

-----Original Message-----
From: Dirschel, Steve [mailto:Steve.[Email Address Removed] Friday, November 30, 2001 3: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
Oracle LazyDBA home page