Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!logbridge.uoregon.edu!pln-w!extra.newsguy.com!lotsanews.com!sjc-peer.news.verio.net!news.verio.net!dfw-read.news.verio.net.POSTED!not-for-mail From: Vince Laurent Newsgroups: comp.databases.oracle.misc Subject: Re: Q: Rollbacks Message-ID: References: X-Newsreader: Forte Agent 1.93/32.576 English (American) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 22 Date: Fri, 08 Aug 2003 14:48:42 -0500 NNTP-Posting-Host: 199.217.149.3 X-Complaints-To: abuse@verio.net X-Trace: dfw-read.news.verio.net 1060372119 199.217.149.3 (Fri, 08 Aug 2003 19:48:39 GMT) NNTP-Posting-Date: Fri, 08 Aug 2003 19:48:39 GMT Organization: NTT/Verio Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:130386 Thanks! On Fri, 08 Aug 2003 20:03:05 +0200, Sybrand Bakker wrote: >On Fri, 08 Aug 2003 10:20:33 -0500, Vince Laurent >wrote: > >>I need to increase the size of the existing rollback segments. I have >>the SQL to do it but am not sure of the timing. Can I take one >>rollback segement offline, increase it, bring it back online, then >>move on to the next? What is the result of taking a rollback segement >>offline if it might be being used? Is there a way to tell the >>rollback segement to go offline once it is idle? > >If the rollback segment is in use, it will go offline once the >transaction has completed. You don't have to do anything for that. >And yes you can change them one at the time -------------------------------------- Come race with us! www.mgpmrc.org