如果我的一个表有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'