Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Large RollbackSegment

Re: Large RollbackSegment

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 15 Nov 2001 13:08:03 +0000
Message-ID: <3BF3BE33.726C@yahoo.com>


Roland Carlsson wrote:
>
> Hi!
> I have got a really large rollbacksegment. It's about twice the size of the
> rest of the database and have of some reason grown very quickly the last
> month. Is there a rollbackAll command I can do to be able to shrink the size
> of the databasefile??
>
> Thanks in advance
> Roland Carlsson

alter rollback segment XXX shrink;
alter database datafile '....' resize ... ;

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."
Received on Thu Nov 15 2001 - 07:08:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US