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使用情况