Rows in a block ?

[denevge]

Something like this ?

select dbms_rowid.ROWID_BLOCK_NUMBER(ROWID), count(*) NumberOfRowsInThisBlock
from Mytable
group by dbms_rowid.ROWID_BLOCK_NUMBER(ROWID)

But, this will not take into account migrated/chained rows.

Gert