Re: Reducing Redo Log

You can:
- use the undocumented parameter _disable_logging to stop writing to the redos.

You should:
- Make sure that the temporary tablespace was created with as type TEMPORARY.

John Vernes wrote:

> 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 Wed Jun 10 1998 - 02:39:47 CDT