Re: real free space in a tablespace
From: E A Macnaghten <ar02_at_dial.pipex.com>
Date: 1995/05/17
Message-ID: <3pdj9f$rlc_at_soap.pipex.net>#1/1
> Is there a way to find actual unused space in a tablespace - not just free extents,
> but space that has not been used for extents?
>
> kenp_at_po3.net.cho.ge.com (Ken Poston)
>
>
in sqlplus (as a DBA):
Date: 1995/05/17
Message-ID: <3pdj9f$rlc_at_soap.pipex.net>#1/1
poston_k_at_cho006.cho.ge.com wrote:
>
> Is there a way to find actual unused space in a tablespace - not just free extents,
> but space that has not been used for extents?
>
> kenp_at_po3.net.cho.ge.com (Ken Poston)
>
>
in sqlplus (as a DBA):
create table tsfree
( tablespace_name char(30),
total_blocks number,
free_blocks number,
contig_blocks number);
insert into tsfree(tablespace_name, total_blocks)
select tablespace_name, sum(blocks)
from sys.dba_data_files
group by tablespace_name;
update tsfree t
set (free_blocks, contig_blocks) =
(select sum(blocks), max(blocks)
from user_free_space u
where u.tablespace_name = t.tablespace_name);
select tablespace_name, total_blocks, contig_blocks,
free_blocks,
round(100*free_blocks/total_blocks,2) percentfree
from tsfree;
The above worked for V6
Yours ever
Eddy Received on Wed May 17 1995 - 00:00:00 CEST