Re: Reducing redolog switch frequence

Rick Denoire wrote:
>
> Daniel Morgan <dmorgan_at_exesolutions.com> wrote:
>
> >100.17706_at_germanynet.de wrote:
> >
>
> >This is a data warehouse or an OLTP application? 10GB of redo logs per hour doesn't
> >strike me as a system that is loaded at 2:00am and put into read-only mode for the
> >following 23 hours.
> >
> >Assuming it is a warehouse, if things went South, would you use the archived redo
> >logs for recovery or just dump the contents and reload?
> >
>
> Most of the time, read operations over millions of records are taking
> place, but the results are of course put into some tables, which are
> not set readonly.
>
> If one knows beforehand that some tables won't be changed during the
> long running operation, would it be possible to set them readonly for
> that particular session? There is the nologging option, but it is not
> applicable to DML transactions.

If you can put the r/o tables in a different tablespace (or the r/w tables) you can switch the tablespace to read only.

Regards,

Knut Received on Wed May 15 2002 - 02:37:04 CDT