Re: URGENT - Can you coalesce a RBS tablespace?

On 9/6/05, Henslee, Jeff <jhenslee_at_wausauwindow.com> wrote:
>
> Apologies - Here's are the error messages I was receiving -
>
> ORA-01562 Failed to extend rollback segment number 11
> ORA-01650 unable to extend rollback segment RBS10 by 128 in tablespace
> RBS.
>
> It started with one user at first and then started to spread to a number
> of users on the same instance.
>
> The weird thing about it was the initial extent of segment 10 was 128. The
> next size was 1M with the optimal size being 5M.

I think its already been suggested that you keep initial=next for rollback segments. This is good advice, especially for RBS - though actually for other segment types as well.

It appeared that it was even having troubles with the initial extent. I
> guess that is why I labeled it 'urgent'. I wasn't sure why it couldn't even
> create the initial extent. The free space still does not appear to be giving
> itself back to the instance....

the 128 in the 1650 error text is blocks not bytes. Most likely you have an 8k block size and its a 1m extent that can't be created.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

--
http://www.freelists.org/webpage/oracle-l