Re: Space Usage Question

I should have said, that whilst further digging will likely be fun, I think we have both demonstrated that you *can* encounter the unusable free space issue as a result of fragmentation of free space when using auto-allocate. Richard has also shown that the circumstances under which this will occur are not readily apparent <g>.

I think Jonathan Lewis pointed out that the pattern of extent allocation under auto-allocate was subject to change from version to version , not sure that it has yet changed, so at least as far as the fragmentation issue goes I'm happy to stick for now with a general preference for ULMTs with differing uniform sizes if necessary for forecasting.

cheers

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK