Thanks for the input, the server is a Dell PowerEdge 6500.
----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, December 31, 2001 11:05 AM > 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). > -- 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).
