prompt Copyright 2001 Reed-Matthews, Inc.
prompt highwater.sql
prompt
prompt Tells you tables that have more than 15% of their blocks empty,
prompt which suggests they might be good candidates for exporting/importing
prompt to tighten up the space usage
set numformat 999,999,999,990
set linesize 132
select substr(owner,1,12) "Owner", substr(table_name,1,35) "Table",blocks "Blocks",empty_blocks "Empty|Blocks",
blocks-empty_blocks,num_rows "Rows",blocks*8192 "Bytes" from sys.dba_tables where blocks-empty_blocks < (.85*blocks) and blocks > 8192 order by (.85*blocks);