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>
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