查看表空间使用情况:
select a.file_id "FileNo",a.tablespace_name "Tablespace_name",
round(a.bytes/1024/1024,4) "Total MB",
round((a.bytes-sum(nvl(b.bytes,0)))/1024/1024,4) "Used MB",
round(sum(nvl(b.bytes,0))/1024/1024,4) "Free MB",
round(sum(nvl(b.bytes,0))/a.bytes*100,4) "%Free"
from dba_data_files a, dba_free_space b
where a.file_id=b.file_id(+)
group by a.tablespace_name,
a.file_id,a.bytes order by a.tablespace_name
查看对象的block_id
select t.owner,t.segment_name,t.segment_type, t.block_id from dba_extents t where t.file_id=4 order by 4 desc
block_id最大的是1113。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22980662/viewspace-696075/,如需转载,请注明出处,否则将追究法律责任。