COLUMN OBJECT_NAME FORMAT A40

COLUMN NUMBER_OF_BLOCKS FORMAT 999,999,999,999

SELECT o.OBJECT_NAME, COUNT(*) NUMBER_OF_BLOCKS

     FROM DBA_OBJECTS o, V$BH bh

    WHERE o.DATA_OBJECT_ID = bh.OBJD

      AND o.OWNER         != 'SYS'

    GROUP BY o.OBJECT_NAME

    ORDER BY COUNT(*);

OBJECT_NAME                              NUMBER_OF_BLOCKS

---------------------------------------- ----------------

OA_PREF_UNIQ_KEY                                        1

SYS_C002651                                             1

..

DS_PERSON                                              78

OM_EXT_HEADER                                         701

OM_SHELL                                            1,765

OM_HEADER                                           5,826

OM_INSTANCE                                        12,644