Reducing redolog switch frequence

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