Re: Reducing redolog switch frequence

100 redo logs per hour (translates into 100 archive logs if you're archiving)
is a lot to recover from. If there was a media failure, in a 24 hour period
(assuming equal load), you'd have 2,400 archive logs to apply. Ouch. Lets hope
they're all good!
I believe you're on the right track, and the other posts give good suggestions
(like larger redo logs) that should help. This won't cut down on the hard disk I/O.
It will reduce the number of redo log switches. If you're writing 1,000MB
of redos per hour, you'll write them in 10MB chunks or in 500MB chunks. But you'll still write them. You may need to do some tuning on the database.
I'd start with the application. Some alternatives were given in other posts.
If the database is badly out of tune, you may get 10% to 15% back with just
database tuning efforts. I've seen 45minute jobs drop to under 10seconds
with application tuning. Hint. Hint.
Good luck.
jc
johnclaxton_at_networkessentials.com
Home of: Get Certified!
Over 1,000 Free Sample Questions
http://www.networkessentials.com/certified/ocp

"100.17706" <100.17706_at_germanynet.de> wrote in message news:abr8ho$5cf$1_at_news.netmar.com

> Hello
>
> We use a data warehouse application (PL/SQL) and produce over 100 redo log
> files 10 MB in size each per hour. In the init parameter file, we have
> log_buffer = 20979712.
>
> What can I do to try to reduce the redo log switch frequence to a healthy
> value of about one per half an hour?
>
> Because this application runs very slow, we assume that harddisk I/O due
> to redo log operations could be a bottleneck.
>
> How can I improve performance by somehow tuning parameters related to
> the redo log files?
>
> The same question would apply to parameters related to rollback segments,
> I guess.
>
> ANY suggestion will be welcome!
>
> Thanks
> Rick
>
>
>
> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web -----
> http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
> NewsOne.Net prohibits users from posting spam. If this or other posts
> made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG