Re: Modify Rollback segment for backup process.

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 11 Mar 2003 07:11:33 +0100
Message-ID: <dfvq6vc9s139duvr7b9803b02qoqeulanl@4ax.com>

On Mon, 10 Mar 2003 22:08:57 -0500, C Chang <cschang_at_maxinter.net> wrote:

>I checked our DB again. The rollback segment is
> INITIAL 20M NEXT 10M MINEXTENTS 2 MAXEXTENTS 10
>sorry for the mistake. My question is because of a one time big
>transaction, do we need to change the rollback segement?

If the rollback segment is properly configured (and maxextents 10 doesn't really look like that) it will grow automatically.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Mar 11 2003 - 00:11:33 CST