-----以前的程式里很多异常都被客制了,让我们无法下手,难道要去上新版来确认问题吗?
-----不要着急,先来看看是不是因为table space不足引起的吧
------
Ditto Xu 徐興付
Select b.File_Id "文件ID",
b.Tablespace_Name "表空间",
b.File_Name "物理文件名",
b.Bytes "总字节数",
(b.Bytes - Sum(Nvl(a.Bytes, 0))) / (b.Bytes) * 100 "已使用百分比",
(b.Bytes - Sum(Nvl(a.Bytes, 0))) "已使用",
Sum(Nvl(a.Bytes, 0)) "剩余",
Sum(Nvl(a.Bytes, 0)) / (b.Bytes) * 100 "剩余百分比"
From Dba_Free_Space a,
Dba_Data_Files b
Where a.File_Id = b.File_Id
And b.Tablespace_Name = 'VSPACED' --'VTEMP'
Group By b.Tablespace_Name,
b.File_Name,
b.File_Id,
b.Bytes
Order By b.Tablespace_Name
b.Tablespace_Name "表空间",
b.File_Name "物理文件名",
b.Bytes "总字节数",
(b.Bytes - Sum(Nvl(a.Bytes, 0))) / (b.Bytes) * 100 "已使用百分比",
(b.Bytes - Sum(Nvl(a.Bytes, 0))) "已使用",
Sum(Nvl(a.Bytes, 0)) "剩余",
Sum(Nvl(a.Bytes, 0)) / (b.Bytes) * 100 "剩余百分比"
From Dba_Free_Space a,
Dba_Data_Files b
Where a.File_Id = b.File_Id
And b.Tablespace_Name = 'VSPACED' --'VTEMP'
Group By b.Tablespace_Name,
b.File_Name,
b.File_Id,
b.Bytes
Order By b.Tablespace_Name