Doc

    Name:    blokrows.sql

    This script lists how many rows are being stored per block
    for a selected table

#

ttitle 'Table Rows Per Block'

SELECT   SUBSTR(T.ROWID,1,8)  || '-' ||
             SUBSTR(T.ROWID,15,4)  BLOCK,
         COUNT(*)                              ROW_CNT
FROM     &TAB_NAME T
WHERE    ROWNUM  <  2000
GROUP BY SUBSTR(T.ROWID,1,8) || '-' || SUBSTR(T.ROWID,15,4);