Re: Number of table and index extents

From: Doug Thomson <thomson_at_toucan.fs.com>
Date: Wed, 26 Jan 1994 18:14:32 GMT
Message-ID: <CK91C8.JuD_at_cardinal.fs.com>


we use the following for free-space analysis:

rem  ================================================
rem      ORACLE DATABASE FREE SPACE QUERY 
rem  ================================================
rem

select tablespace_name,
round(sum(bytes / 1048576)) "total MB allocated" from dba_data_files
group by tablespace_name;  

select tablespace_name,
round(sum(bytes / 1048576)) "total MB available" from sys.dba_free_space
group by tablespace_name;

it of course does not get down to the level of extents. There are a couple of queries in the V6 DBA class notes that could help you in this respect.

Doug Thomson
Fourth Shift Corp.
Minneapolis, MN
(612) 851-1471
thomson_at_fs.com Received on Wed Jan 26 1994 - 19:14:32 CET

Original text of this message