Apologies - Here's are the error messages I was receiving - ORA-01562
Failed to extend rollback segment number 11ORA-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.
Sent: Tuesday, September 06, 2005 3:59 PM
To: Henslee, Jeff
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.
Certifiable Oracle DBA and Part Time Perl Evangelist
On 9/6/05, Henslee, Jeff <jhenslee@(protected):
> 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