Reducing Redo Log

We have a relatively large database (40GB on Workgroup Server 7.3.3.5 on NT) here and some parts of our application produce lots of redo log. In excessive situations above 3 GB per hour, up to three switches (4 * 900MB single member redo log files).

I know a couple of options to reduce this redo log, but I wonder if there are more options beyond my knowledge.

Ways to reduce redo log are, by my knowledge the following:
* Create table UNRECOVERABLE as select ....

• Create index UNRECOVERABLE ....
• Create indexes on tables after you read the data into your table
• Create less indexes on the tables

Questions:
* Does the size of the PCTFREE parameter effect the redo size?

• I mean to remember that in Oracle 8 it must be possible to reduce the redo log when using the statement ALTER TABLE ...... NOLOG; This should work for parallel insert, but also for serial inserts as I recall. Has anyone played with this feature and if so do you have some results for me?
• Are there other ways to reduce the redo log size?

Thanxs and Greetz

John Received on Fri Jun 05 1998 - 16:50:16 CDT