Re: Redo Logs Question

Thanks for the input, the server is a Dell PowerEdge 6500.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> 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: Stephen.Karniotis_at_Compuware.com
> 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: tschruefer_at_mail.howard.k12.md.us
>
> 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: ListGuru_at_fatcity.com (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: Stephen_Karniotis_at_compuware.com
>
> 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: ListGuru_at_fatcity.com (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: tschruefer_at_mail.howard.k12.md.us

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: ListGuru_at_fatcity.com (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).