如何查看oracle表空间已使用大小Oracle认证考试
文章作者 100test 发表时间 2010:03:05 22:17:35
来源 100Test.Com百考试题网
1.查看所有表空间大小:
Sql代码
0select tablespace_name,sum(bytes)/1024/1024 from dba_data_files group by tablespace_name.
2.已经使用的表空间大小:
Sql代码
0select tablespace_name,sum(bytes)/1024/1024 from dba_free_space group by tablespace_name.
3. 所以使用空间可以这样计算:
Sql代码
0select a.tablespace_name,total,free,total-free used from
( 0select tablespace_name,sum(bytes)/1024/1024 total from dba_data_files
group by tablespace_name) a,
( 0select tablespace_name,sum(bytes)/1024/1024 free from dba_free_space
group by tablespace_name) b
where a.tablespace_name=b.tablespace_name.