>      Hi Ari,
>      
>      I had a quick question.  Have you ever seen where the tablespace for 
>      rollback segments becomes so fragmented that a rollback segment can't 
>      get the next extent?
>      

The tablespace could get fragmented, but should never cause a rollback segment
to fail to extend. The only cases where this should happen are with

* Rollback segments with PCTINCREASE > 0
* Rollback segments of different INITIAL/NEXT sizes within the same tablespace

Try to coalesce the free space in the rollback tablespace:

Oracle 7.3:
----------
* alter tablespace RBS coalesce;

Before Oracle 7.3:
-----------------
* alter tablespace rbs default storage (pctincrease 1);
  (wait 15 minutes)
* alter tablespace rbs default storage (pctincrease 0);
This causes the background process to coalesce the free space when it wakes up.



-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 90+ Oracle tips, visit my Web Page:                       <->
<->                                                               <->
<->              www.arikaplan.com                                <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page k to Ari Kaplan's Home Page