analyze table &owner.&table_name compute statistics
/
SELECT
blocks
FROM
dba_segments
WHERE
owner = '&&owner'
AND segment_name = '&&table_name'
/
SELECT
empty_blocks
FROM
dba_tables
WHERE
owner = '&&owner'
AND table_name = '&&table_name'
/
HIGHWATER_MARK = dba_segments.blocks - dba_tables.empty_blocks - 1
确定Oracle中某张表的High Water Mark
最新推荐文章于 2024-08-30 10:18:21 发布