分类:
2012-03-31 20:49:42
原文地址:Oracle 查询某个表所占空间 作者:zzjlzx
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>