There are two X$ tables that expose the used and free extents in locally
managed tablespaces. They are X$KTFBUE and X$KTFBFE respectively.
However, you don't need to worry about querying these structures
directly. The DBA_SEGMENTS, DBA_EXTENTS, DBA_FREE_SPACE,
DBA_FREE_SPACE_COALESCED, DBA_DATA_FILES, DBA_TABLESPACES, and
DBA_TEMP_FILES data dictionary view families all query these X$
structures and call DBMS_SPACE_ADMIN as required, so all your existing
scripts should continue to work correctly.

However, it should be noted that these querying these views has a much
greater performance impact for locally managed tablespaces than for
dictionary managed ones, and therefore such scripts should be used
sparingly.


-----Original Message-----
Sent: Thursday, 24 August 2000 7:01


Is there any way that one can view the extent bitmap in a locally managed
tablespace ? I would like to see things like average extents per object,
% of extents used for tables within it, objects that cannot grow,
fragmented space, etc.