You are here

High Water Mark

Metalink article 262353.1

 

essentially

 

select count (distinct dbms_rowid.rowid_block_number(r.rowid)) "used blocks", blocks "below hwm", empty_blocks "above hwm"
from <table_name> r, dba_tables
where table_name = '<table_name>'
group by blocks, empty_blocks;