RE: Estimate space need in RBS for a table rebuild

From: Sheehan, Jeremy <JEREMY.SHEEHAN_at_nexteraenergy.com>
Date: Tue, 9 Apr 2013 12:53:24 +0000
Message-ID: <939730CDCC52DA43AB03D00E4C678B9C349A52_at_GOXSA1707.fplu.fpl.com>



If you're using Grid control, you can look at the segment advisor. This will give you a good idea on how much space is actually being used by the table. If you "alter table move" or use CTAS, you won't need UNDO.

Jeremy

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeffrey Beckstrom Sent: Tuesday, April 09, 2013 7:58 AM
To: oracle-l-freelists; oracle-db-l
Subject: Estimate space need in RBS for a table rebuild

Anybody know of a why to estimate the amount of space needed in the Rollback Segment Tablespace for a given table rebuild.    

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority Information Systems 1240 W. 6th Street
Cleveland, Ohio 44113

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 09 2013 - 14:53:24 CEST

Original text of this message