URGENT - Can you coalesce a RBS tablespace? 2005-09-06 - By Chirag DBA
Try setting the OPTIMUM parameter, which will reduce the size of yr segment
after finishing the transaction. That can help you to get through.
But if the transactions are long, they can generate 1555 erros in yr trace
files.
Look for this too.
Regards - Chirag
On 9/6/05, Mercadante, Thomas F (LABOR) <
Thomas.Mercadante@(protected)> wrote:
>
> Jeff,
>
> Have you shrunk the existing rollback segments? You may have some that
> are huge in size. You can shrink them and this will free up space in
> the RBS tablespace.
>
> Tom
>
> -- --Original Message-- --
> From: oracle-l-bounce@(protected)
> [mailto:oracle-l-bounce@(protected)] On Behalf Of Henslee, Jeff
> Sent: Tuesday, September 06, 2005 12:55 PM
> To: Oracle-L Freelists
> Subject: URGENT - Can you coalesce a RBS tablespace?
>
> We seem to be having troubles with some of our RBS segments. We are
> unable to create new segments or extend existing ones. This is an
> unusual pattern and we're trying to find a way to get people back
> working again without having to add a datafile to the RBS area (if at
> all possible) or restart the instance.
>
> Options please?
>
> Thank you.
>
> Jeffrey C. Henslee (Chico)
> Six Sigma Green Belt
> Wausau Window and Wall Systems
> (715) 846-3196
> mailto:jhenslee@(protected)
>
> --
> http://www.freelists.org/webpage/oracle-l
> --
> http://www.freelists.org/webpage/oracle-l
>
<div>Try setting the OPTIMUM parameter, which will reduce the size of yr
segment after finishing the transaction. That can help you to get through.</div
>
<div> </div>
<div>But if the transactions are long, they can generate 1555 erros in yr trace
files.</div>
<div> </div>
<div>Look for this too.</div>
<div> </div>
<div>Regards - Chirag <br><br> </div>
<div><span class="gmail_quote">On 9/6/05, <b class="gmail_sendername"
>Mercadante, Thomas F (LABOR)</b> <<a href="mailto:Thomas.Mercadante@(protected)
.state.ny.us">Thomas.Mercadante@(protected)</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">Jeff,<br><br>Have you shrunk the existing
rollback segments? You may have some that<br>are huge in size.
You can shrink them and this will free up space in
<br>the RBS tablespace.<br><br>Tom<br><br>-- --Original Message-- --<br>From:
<a href="mailto:oracle-l-bounce@(protected)">oracle-l-bounce@(protected)</a>
<br>[mailto:<a href="mailto:oracle-l-bounce@(protected)">oracle-l-bounce
@(protected)
</a>] On Behalf Of Henslee, Jeff<br>Sent: Tuesday, September 06, 2005 12:55 PM
<br>To: Oracle-L Freelists<br>Subject: URGENT - Can you coalesce a RBS
tablespace?<br><br>We seem to be having troubles with some of our RBS segments.
We are
<br>unable to create new segments or extend existing ones. This is
an<br>unusual pattern and we're trying to find a way to get people back<br
>working again without having to add a datafile to the RBS area (if at<br>all
possible) or restart the instance.
<br><br>Options please?<br><br>Thank you.<br><br>Jeffrey C. Henslee (Chico)<br
>Six Sigma Green Belt<br>Wausau Window and Wall Systems<br>(715) 846-3196<br
>mailto:<a href="mailto:jhenslee@(protected)">jhenslee@(protected)
</a><br><br>--<br><a href="http://www.freelists.org/webpage/oracle-l">http:/
/www.freelists.org/webpage/oracle-l</a><br>--<br><a href="http://www.freelists
.org/webpage/oracle-l">http://www.freelists.org/webpage/oracle-l</a>
<br></blockquote></div><br>
|
|
