On Thu, 14 Mar 2002, Post, Ethan wrote: > (HJR) recommends one switch per day (manually) if possible and not > more than once per hour. This is all to limit when a checkpoint > actually occurs.
Ok, this must by a troll. Once a day? Manually? Is he kidding? A checkpoint is a normal thing. It is minimally impactful, and takes up a very small proportion of the DBW0 write batch. Real sites checkpoint all the time under heavy usage conditions and nobody gets hurt. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > -----Original Message----- > Sent: Thursday, March 14, 2002 8:19 AM > To: Multiple recipients of list ORACLE-L > > An Oracle Support technician recommended that I try to aim for three log > switches per hour, during busy times. > > According to the throughput I got yesterday between 3 and 4 o'clock PM, my > redo log files would each have to be 1G in size. > > That seems much too large to me, and I am not even sure it is possible to > create redo log files that size. Under Oracle 7.3. the largest I could > create on Tru64 UNIX 4.0g was 40M redo log files. > > Is this another "rule of thumb" that should go down the drain? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
