zp7412 发表于 2018-9-23 12:49:31

AIX ORACLE IMP异常扩表空间一例

1、查询USERS表空间使用状况　　Select a.Tablespace_Name, a.Total || 'M' Total_Space, (a.Total - b.Free) || 'M' Used_Space, To_Char((a.Total - b.Free) / a.Total * 100, '99.99') || '%' Pct_Free
　　From
　　(Select Tablespace_Name, Sum(Bytes) / 1024 / 1024 Total From Dba_Data_Files Group By tablespace_Name) a,
　　(Select Tablespace_Name, Sum(Bytes) / 1024 / 1024 Free From Dba_Free_Space Group By Tablespace_Name) b where a.Tablespace_Name = b.Tablespace_Name

页: [1]
查看完整版本: AIX ORACLE IMP异常扩表空间一例