查看表空间大小 oracle

[1]

http://www.google.com.hk/search?hl=en&source=hp&q=%E6%9F%A5%E7%9C%8B%E8%A1%A8%E7%A9%BA%E9%97%B4%E5%A4%A7%E5%B0%8F+oracle&aq=f&oq=&aqi=

[2]

http://topic.csdn.net/u/20070612/10/01978ccd-a70a-48d8-8852-459433bd2385.html

select ff.s tablespace_name,
ff.b total,
(ff.b - fr.b) usage,
fr.b free,
round((ff.b - fr.b) / ff.b * 100) || '% ' usagep
from (select tablespace_name s, sum(bytes) / 1024 / 1024 b
from dba_data_files
group by tablespace_name) ff,
(select tablespace_name s, sum(bytes) / 1024 / 1024 b
from dba_free_space
group by tablespace_name) fr
where ff.s = fr.s
求表空间 空间大小 使用多少空间 剩余多少空间

[3]

http://topic.csdn.net/u/20080516/13/bddfd6c9-cd08-4a8f-ada1-d6e4459166ae.html

select tablespace_name, sum(nvl(bytes,0))/1024/1024 free from dba_free_space where
tablespace_name='tsp_yygl' group by tablespace_name

[4]

http://topic.csdn.net/t/20060830/09/4985382.html

SELECT bytes FROM v$datafile; --看数据库文件大小
结合 v$tablespace可以看表空间的文件结构和大小