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.
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