Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!rip!c03.atl99!news.webusenet.com!news.maxwell.syr.edu!iad-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: Q: Rollbacks Message-ID: 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: 9 Date: Fri, 08 Aug 2003 10:20:33 -0500 NNTP-Posting-Host: 199.217.149.3 X-Complaints-To: abuse@verio.net X-Trace: dfw-read.news.verio.net 1060356030 199.217.149.3 (Fri, 08 Aug 2003 15:20:30 GMT) NNTP-Posting-Date: Fri, 08 Aug 2003 15:20:30 GMT Organization: NTT/Verio Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:130378 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? Thanks -vince