Денормализация данных

Попробуем измерить её в ширину :-)

SQL> SELECT *
  2    FROM (
  3        SELECT c.owner, c.table_name, COUNT(*)
  4          FROM dba_tab_columns c
  5              ,dba_objects o
  6              ,applsys.fnd_oracle_userid fou
  7         WHERE o.owner = fou.oracle_username
  8           AND o.owner = c.owner
  9           AND o.object_name = c.table_name
 10           AND o.object_type = 'TABLE'
 11           AND fou.oracle_username NOT LIKE 'XX%'
 12         GROUP BY c.owner, c.table_name
 13         ORDER BY COUNT(*) DESC
 14  )
 15   WHERE ROWNUM <= 30
 16  /

OWNER      TABLE_NAME                       COUNT(*)
---------- ------------------------------ ----------
BIS        EDWCMPALLCLASSES                      729
IGF        IGF_AP_CSS_INTERFACE_ALL              689
EC         ECE_STAGE                             519
ONT        OE_LINE_ACKS                          507
ICX        ICX_CAT_ITEMS_GT                      500
ICX        ICX_CAT_UPLOAD_IT_DUMP                500
ENI        EDW_ITEMS_M                           495
IGF        IGF_AP_ISIR_INTRFACE_ALL              475
CSI        CSI_HISTORY_ARCHIVE                   473
ONT        OE_LINES_IFACE_ALL                    467
CS         CS_INCIDENTS_AUDIT_B                  432
AMS        AMS_LIST_ENTRIES                      416
AMS        AMS_IMP_SOURCE_LINES                  416
EGO        EGO_BULKLOAD_INTF                     402
IGF        IGF_AP_CSS_FNAR_ALL                   371
ONT        OE_BLANKET_LINES_HIST                 371
AMS        AMS_LIST_IMPORT_ERRORS                367
INV        MTL_SYSTEM_ITEMS_INTERFACE            358
ONT        OE_ORDER_LINES_HISTORY                357
AR         HZ_CUSTOMER_MERGE_LOG                 356
ICX        ICX_POR_UPLOAD_IT_DUMP                345
ONT        OE_HEADER_ACKS                        341
ONT        OE_ORDER_LINES_ALL                    340
ICX        ICX_CAT_ITEMS_TLP                     339
RLM        RLM_INTERFACE_LINES_ALL               339
INV        MTL_SYSTEM_ITEMS_B                    337
ONT        OE_HEADERS_IFACE_ALL                  330
IGF        IGF_AP_CSS_PROFILE_ALL                328
OSM        AS_IMPORT_INTERFACE                   327
QRM        QRM_SAVED_ANALYSES_ROW                327

30 строк выбрано.