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: 64133
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: Thu Dec 08 04:24:14 CST 2016

Total time taken to generate the page: 0.43749 seconds