TABLESPACE_NAME :Name of the tablespace containing the extent
FILE_ID :ID number of the file containing the extent
BLOCK_ID :Starting block number of the extent
BYTES : Size of the extent in bytes
BLOCKS : Size of the extent in Oracle blocks
RELATIVE_FNO : Relative file number of the first extent block
FILE_ID :ID number of the file containing the extent
BLOCK_ID :Starting block number of the extent
BYTES : Size of the extent in bytes
BLOCKS : Size of the extent in Oracle blocks
RELATIVE_FNO : Relative file number of the first extent block
FILE_ID 文件ID
BLOCK_ID 开始的BLock iD
BYTES extends的大小
BLOCKS extends的大小(多少块)
RELATIVE_FNO 相关的文件个数查询可以这么做:
select sum(bytes)/1024 from dba_free_space where tablespace_name='TEMP';