Re: Rollback Segment Question

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Mon, 11 Apr 2005 21:01:46 +0200
Message-ID: <d3ehiq$trt$1@nntp.fujitsu-siemens.com>

<amerar_at_iwc.net> schrieb im Newsbeitrag news:1113245745.494667.176040_at_f14g2000cwb.googlegroups.com...
>
> Frank van Bortel wrote:
> > amerar_at_iwc.net wrote:
> > > Hey All,
> > >
> > > Take a look at the results of this query. Why is it that rollback
> > > segment 23 (RBS23) seems to have all the extends?
> >
> > The usual reason... a long running transaction.
> >
> > And... time to upgrade.
> > Now, how do I know that?
> > --
> > Regards,
> > Frank van Bortel
>
> If I can ever convince this palce to upgrade to 9i to 10g, it would be
> a miracle. They are so damn scared of every little change.....
This is something the DBA has to insist on from day one. Patches and upgrades *will* be done and problems *will* be solved on a test machine with oracle or 3th party support. Otherwise the situation will only get more scary.

Greetings!
Volker Received on Mon Apr 11 2005 - 14:01:46 CDT