不过你的undo表空间使用率过高有些不太好重建一个undo表空间再切换一下 alter system set undo_tablespace=new_undotbs_name;删除以前那个undo表空间
SQL> select 2 a.TABLESPACE_NAME, 3 a.total,nvl(b.used,0) USED, 4 nvl((b.used/a.total)*100,0) PCT_USED 5 from 6 (select TABLESPACE_NAME, 7 sum(bytes)/(1024*1024) total 8 from sys.dba_data_files 9 group by TABLESPACE_NAME) a, 10 (select TABLESPACE_NAME,bytes/(1024*1024) used 11 from sys.SM$TS_USED) b 12 where a.TABLESPACE_NAME=b.TABLESPACE_NAME(+);TABLESPACE_NAME TOTAL USED PCT_USED ------------------------------ ---------- ---------- ---------- SYSAUX 330 317.5 96.2121212 UNDOTBS1 140 19.4375 13.8839286 USERS 1370 1367 99.7810219 SYSTEM 660 658.9375 99.8390152 EXAMPLE 100 78.125 78.125
alter system set undo_tablespace=new_undotbs_name;删除以前那个undo表空间
2 a.TABLESPACE_NAME,
3 a.total,nvl(b.used,0) USED,
4 nvl((b.used/a.total)*100,0) PCT_USED
5 from
6 (select TABLESPACE_NAME,
7 sum(bytes)/(1024*1024) total
8 from sys.dba_data_files
9 group by TABLESPACE_NAME) a,
10 (select TABLESPACE_NAME,bytes/(1024*1024) used
11 from sys.SM$TS_USED) b
12 where a.TABLESPACE_NAME=b.TABLESPACE_NAME(+);TABLESPACE_NAME TOTAL USED PCT_USED
------------------------------ ---------- ---------- ----------
SYSAUX 330 317.5 96.2121212
UNDOTBS1 140 19.4375 13.8839286
USERS 1370 1367 99.7810219
SYSTEM 660 658.9375 99.8390152
EXAMPLE 100 78.125 78.125
可以去看看。