test23_1

Argument Name                  Type                    In/Out Default?
 ----------------- ----------------------- ------ --------
 SEGMENT_OWNER                  VARCHAR2                IN
 SEGMENT_NAME                   VARCHAR2                IN
 SEGMENT_TYPE                   VARCHAR2                IN
 TOTAL_BLOCKS                   NUMBER                  OUT
 TOTAL_BYTES                    NUMBER                  OUT
 UNUSED_BLOCKS                  NUMBER                  OUT
 UNUSED_BYTES                   NUMBER                  OUT
 LAST_USED_EXTENT_FILE_ID       NUMBER                OUT
-- the file ID of the last extent which contains data
 LAST_USED_EXTENT_BLOCK_ID      NUMBER                OUT
--block ID of the last extent which contains data
 LAST_USED_BLOCK                NUMBER                  OUT
  -- last block within this extent which contains data
 PARTITION_NAME                 VARCHAR2                IN     DEFAULT

用一个脚本就可以知道某表的高水平位了，如下：
declare
u1 number;u2 number;u3 number;u4 number;u5 number;u6 number;u7 number;
begin
DBMS_SPACE.UNUSED_SPACE('TEST','WD','TABLE',u1,u2,u3,u4,u5,u6,u7);
dbms_output.put_line(u5||u6||u7);
end;
运行之后可以知道表wd的block使用情况