Home » RDBMS Server » Server Administration » does log switch take place at 1/3 full redo-log buffer ?
does log switch take place at 1/3 full redo-log buffer ? [message #336396] Sat, 26 July 2008 05:47 Go to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
when the redo-log is 1/3rd full a LGWR would write to red-log files. But does a log-switch also take place if the redo-log buffer is 1/3rd full ?

Re: does log switch take place at 1/3 full redo-log buffer ? [message #336418 is a reply to message #336396] Sat, 26 July 2008 10:18 Go to previous message
Michel Cadot
Messages: 64841
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No. You mixed log buffer and log file.
When log BUFFER is one third full it is flushed inside log FILE.
Log file switches only when it is full (or you ask it to switch with alter system).

Regards
Michel
Previous Topic: What extent size would your recommend here (uniform tablespace)?
Next Topic: converting permanent tablespace to temporary tablespace
Goto Forum:
  


Current Time: Sun May 28 21:09:11 CDT 2017

Total time taken to generate the page: 0.19126 seconds