Re: RBS full

zeb wrote:
>
> Hi,
>
> After a lot of modifications to the database
> (night batches), the tablespace RBS stay full
> all the the batches are OK and committed ...
>
> Why the RBS is not emptied after all the transactions are committed ???
>
> Thanks in advance
>
> Oracle 8.1.7
> AIX 4.3
Those rbs blocks remain so that people can get read consistent views of the data (just in case their queries began before the large transactions commenced)

They will be reused eventually

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."