URGENT - Can you coalesce a RBS tablespace? 2005-09-07 - By Niall Litchfield
On 9/6/05, Henslee, Jeff <jhenslee@(protected)> wrote:
>
> Apologies - Here's are the error messages I was receiving -
>
> ORA-01562 (See ORA-01562.ora-code.com) Failed to extend rollback segment number 11
> ORA-01650 (See ORA-01650.ora-code.com) 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
On 9/6/05, <b class="gmail_sendername">Henslee, Jeff</b> <<a href="mailto
:jhenslee@(protected)">jhenslee@(protected)</a>> wrote:<div><span
class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left:
1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Apologies - Here's are the error messages I was receiving -<br><br>ORA-01562 (See ORA-01562.ora-code.com)
Failed to extend rollback segment number 11<br>ORA-01650 (See ORA-01650.ora-code.com) unable to extend
rollback segment RBS10 by 128 in tablespace RBS.<br><br>It started with one
user at first and then started to spread to a number of users on the same
instance.
<br><br>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.<
/blockquote><div><br>
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. <br>
</div><br><blockquote class="gmail_quote" style="border-left: 1px solid
rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">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....</blockquote><div><br>
</div></div>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. <br><br clear="all"><br>-- <br>Niall Litchfield<br>Oracle DBA<br><a
href="http://www.niall.litchfield.dial.pipex.com">http://www.niall.litchfield
.dial.pipex.com</a>
|
|
