Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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:Received on Tue Sep 06 2005 - 16:01:26 CDT
>
> 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
![]() |
![]() |