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 ?

Report message to a moderator

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: 68675
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 08 23:34:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.