Re: Reducing redolog switch frequence

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Wed, 15 May 2002 00:04:48 +0200
Message-ID: <nr13eu0u7dio7jv8276n3kut4v1m4ikglh@4ax.com>

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.

Using:
Oracle 8.1.7
Solaris 7
Sun E3500

Bye
Rick Received on Tue May 14 2002 - 17:04:48 CDT