Bug in dba_free

From: Chuck <chuckh_nospam_at_softhome.net>
Date: Mon, 6 May 2002 15:54:00 -0400
Message-ID: <ab6n0s$fkahh$1@ID-85580.news.dfncis.de>

Can someone tell me what's going on here? I always thought that the size of the allocated extents plus the free space in a datafile would equal the total size of the datafile. That doesn't appear to be true with this file. I think dba_free_space or dba_extents is missing something. BTW this datafile is the sole datafile of a locally managed tablespace.

select 'free space' block_class,sum(bytes)/1048576 megabytes from dba_free_space where file_id = 733
union all
select 'used extents',sum(bytes)/1048576 megabytes from dba_extents where file_id = 733
union all
select 'total in file',sum(bytes)/1048576 megabytes from dba_data_files where file_id = 733;

Here's the results. They don't add up.

BLOCK_CLASS MEGABYTES
------------- ----------

free space           200
used extents        1400
total in file       1700

Platform: SGI IRIX64
Oracle version: 8.1.7.2.0 (the current 8i patch for IRIX). Received on Mon May 06 2002 - 14:54:00 CDT

Bug in dba_free_space?