Tom: File sizes of 5k are not good. If you have the room on your server, I would increase that significantly. Perhaps to 50-60m. Log switching every 90 sec. is not good.
There are many INIT.ORA parameters that control the performance of redo logs. LOG_BUFFERS or LOG_BUFFER_SIZE is one of them. This defaults, I believe, to 32k. Increase this to over 512k. There are many more. Look at your INIT.ORA settings. Also, if you can identify the type of hardware you are running as a database server, we can give you some additional choices. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -----Original Message----- Sent: Monday, December 31, 2001 10:20 AM To: Multiple recipients of list ORACLE-L Subject: Redo Logs Question Here is the background of the stiuation I am facing. We are piloting a application that uses a hybred store and forward system to aggregate all of our disparate student data into one central database. Currently there are 20 schools integrated into the system with another 48 to go, those 20 schools hold about half of our 46k student population. The system allows (requires) student demographics to be entered through a web client, while grades, attendance, health, conduct, etc. are uploaded over night. The system comes with the redo log file size set to 5k, which when the users in the 20 pilot schools get going causes a log switch about every 90 seconds. In my limited, steep learning curve expereince, this does not seem like a good thing. Add to that, they cancelled the Oracle Tuning class, which I have to wait until the system is in to take now. So my questions (that the books don't really seem to want to answer): How frequently should redo log file switches occur? How large should my redo logs be? I am guessing the answer to both of these questions is, It Depends. So my question really is, how do I determine what the correct settings for my installation are? Tom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen 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).
