Tablespace fragmentation map
From: <brooksa_at_logica.com>
Date: 1996/03/14
Message-ID: <4i9iav$jac_at_romeo.logica.co.uk>#1/1
Date: 1996/03/14
Message-ID: <4i9iav$jac_at_romeo.logica.co.uk>#1/1
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