- 论坛徽章:
- 0
|
SQL> select TABLESPACE_NAME,sum(bytes)/1024/1024 from dba_segments where owner='a'
group by TABLESPACE_NAME;
TABLESPACE_NAME SUM(BYTES)/1024/1024
------------------------------ --------------------
TBS_CLEAR 29550
TBS_DATA_01 658950.625
TBS_DATA_02 728873.563
TBS_INDEX_00 295845
SQL> select TABLESPACE_NAME,sum(bytes)/1024/1024 from dba_extents where owner='a'
group by TABLESPACE_NAME;
TABLESPACE_NAME SUM(BYTES)/1024/1024
------------------------------ --------------------
TBS_CLEAR 28854.0625
TBS_DATA_01 329391.75
TBS_DATA_02 409907.25
TBS_INDEX_00 237509.688
为什么不一致? 而且为什么dba_segments表比dba_extents表的统计值大。而实际dba_extents表的结果是对的。
请各位高手帮我解释一下,谢谢! |
|