Re: real free space in a tablespace
From: Dave Opdycke <pme_at_crash.cts.com>
Date: 1995/05/18
Message-ID: <D8sn16.8x8_at_crash.cts.com>#1/1
Date: 1995/05/18
Message-ID: <D8sn16.8x8_at_crash.cts.com>#1/1
The following should do it:
conn sys/password
select sum(length)
from ts$,fet$
where ts$.ts#=fet$.ts#
and name = 'TABLESPACE_NAME'
This of course will give you the total number of BLOCKS available, you may want to modify to give max(length) -- so that you can see the largest object that you can create...or not group at all to see all segments of free space...
DPO Received on Thu May 18 1995 - 00:00:00 CEST