Re: Reducing redolog switch frequence

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Thu, 16 May 2002 00:14:33 +0200
Message-ID: <1bn5euogqkfamql511lfe5371gc4vr49fo@4ax.com>

Knut Talman <knut.talman_at_mytoys.de> wrote:

>> 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.

Can that be done by the running transaction or at least on a per session basis?

Rick Received on Wed May 15 2002 - 17:14:33 CDT