"Jesse, Rich" wrote: > > OK, once again, this isn't what I'm looking for. Comparing NEXT_EXTENT*2 to > the largest free space will only work in some cases. Consider that a > segment has NEXT_EXTENT of 30M and there are two 40M free spaces in the TS. > The segment clearly has enough room to extend twice, but comparing > NEXT_EXTENT*2 to the largest free space may not see this. > > I've changed the subject back to reflect the original thread that I started. > > Thanks, > Rich > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA >
http://www.oriole.com/scripts/segtrbl8.sql ? -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
