I am trying to construct a query that will return a list of the total
sizes of blocks of contiguous free space in a tablespace.
I have tried to use the dba_free_space table but cannot see how I can
achieve 'contiguous' part.
I am using Oracle 6.0.32 (!) and would like to use this information for
assessing the optimal size for new a object's initial extent and I don't
want to defragment the tablespace!
--
Adrian Brooks
Any views expressed are my own and not of my employer.
Received on Thu Mar 14 1996 - 00:00:00 CET