You can make an estimate of how many blocks are used for data in a table.
select count(distinct(dbms_rowid.rowid_block_number(row_id))) from MyTable;
gives you the number of blocks in MyTable that are used for storing data.
Hope this helps
Gert
|
Results 1 to 8 of 8
Thread: Used SpaceThreaded View
|
Click Here to Expand Forum to Full Width |