RE: URGENT - Can you coalesce a RBS tablespace?

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.

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....

Thanks for asking for the follow-up - I want to make sure that I too, contribute to this forum.

Jeff

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jared Still Sent: Tuesday, September 06, 2005 3:59 PM To: Henslee, Jeff
Cc: chiragdba_at_gmail.com; Oracle-L Freelists Subject: Re: URGENT - Can you coalesce a RBS tablespace?

Glad to see your problems have abated somewhat.

Many of us would still like to know what indications you saw (error message?) that identified rollback segments as the source of the problem.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist


On 9/6/05, Henslee, Jeff <jhenslee_at_wausauwindow.com> wrote:


>  

> I think things have slowed down a little bit.  I am over the hump by trying

> a number of suggestions from a number of you (and I thank you all). 

>   

> I have tried to shrink a number of the roll back segments - although I'm not

> sure I was 100% successful - the segment size in OEM did not change much at

> all.  If I add the segments that were unusually large, basically, they

> consume almost the entire datafile (1GB) - 

>   

> I did try to kill a couple of older user connections that were very old and

> stale.  

>

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