柔中带刚，刚中带柔，淫荡中富含柔和，刚猛中荡漾风骚，无坚不摧，无孔不入！
全部博文（1669）
分类： Oracle
2011-12-05 16:18:40
SQL>
SQL> SELECT segment_name AS TABLENAME,
2 BYTES B,
3 BYTES / 1024 KB,
4 BYTES / 1024 / 1024 MB
5 FROM user_segments
6 where segment_name in ('DIM_CUSTOMER', 'FACT_SALES_INVC', 'FACT_SALES_ITEM',
7 'DIM_STORE', 'DIM_INVN_ITEM')
8 order by bytes desc;
TABLENAME B KB MB
-------------------------------------------------------------------------------- ---------- ---------- ----------
FACT_SALES_ITEM 184549376 180224 176
FACT_SALES_INVC 146800640 143360 140
DIM_CUSTOMER 75497472 73728 72
DIM_INVN_ITEM 49283072 48128 47
DIM_STORE 65536 64 0.0625
SQL>
