Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!sn-xit-03!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.misc Subject: Re: Q: Rollbacks Date: Fri, 08 Aug 2003 20:03:05 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: postbus@sybrandb.demon.nl 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 X-Complaints-To: abuse@supernews.com Lines: 21 Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:130383 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? > >Thanks >-vince 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 Sybrand Bakker, Senior Oracle DBA To reply remove -verwijderdit from my e-mail address