查询某表空间的使用情况信息

hejisan

于 2013-05-25 09:05:54 发布

阅读量785

点赞数

分类专栏： oracle 文章标签： Oracle

oracle 专栏收录该内容

7 篇文章

订阅专栏

Select t.tablespace_name name,d.allocated allocated_MB,u.used used_MB,
f.free free_MB,t.status,d.cnt,contents,t.extent_management extman,
t.segment_space_management segman
t from dba_tablespaces t,
(select sum(bytes)/1024/1024 allocated,count(file_id) cnt from dba_data_files where tablespace_name='&&tablespace_name')d,
(select sum(bytes)/1024/1024 free from dba_free_space
Where tablespace_name='&tablespace_name')f,
(select sum(bytes)/1024/1024  used from dba_segments
Where tablespace_name='&tablespace_name')u
Where t.tablespace_name='&tablespace_name';