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
Received on Tue Sep 06 2005 - 16:01:26 CDT
