Calculating when a segment will need a new extent

Hi,

Is there a good (as in relatively accurate) way of finding out how much room is left in the latest allocated extent for a table or index segment? Or put another way is there a way of figuring out which segments are close to needing an extra extent?

This info could be used together with info on #extents, extent sizes and free space to see where any space problems may occur soon.

Thanks in advance for any help!

Please email any answer to me at cje_at_stibo.com since I don't read news regularly!

Claus Jensen. Received on Fri Oct 17 1997 - 00:00:00 CDT