Re: rollback segment keeps growing

From: <arnaud.riess_at_uhp.u-nancy.fr>
Date: Wed, 08 Dec 1999 16:13:02 GMT
Message-ID: <82m028$bhp$1@nnrp1.deja.com>

> There are a couple of things you can do:
> 1) Set you optimal parameter which should probably equal you next
> extents X minimun extent number and your initial and next extent sizes
> should match for rbs segments
>
> This will provide automatic release of unused extents
>

So if you don't specify an optimal size, your rollback segments are never released even when there isn't any active transaction ? What happens when they're all used after a while ?

Arnaud.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 08 1999 - 10:13:02 CST