请问一个数据空间的问题。。。

如果我的一个表有20个字段,都是varchar2(10)类型的,有100万条记录,请大家告诉我大概会占有oracle的多少磁盘空间??
---------------------------------------------------------------

select SUM(BYTES) from USER_extents
GROUP BY SEGMENT_NAME
HAVING SEGMENT_NAME='TABLENAME'

select SEGMENT_NAME,SUM(BYTES) from DBA_extents
WHERE owner='USER_NAME'
GROUP BY SEGMENT_NAME
HAVING SEGMENT_NAME='TABLE_NAME'

Published At
Categories with 数据库类
comments powered by Disqus