ShrinkUndo表空间,释放空间(3)

文章作者 100test 发表时间 2007:03:14 13:47:40
来源 100Test.Com百考试题网

4.切换undo表空间为新的undo表空间
sql> alter system set undo_tablespace=undotbs2 scope=both.
system altered.



此处使用spfile需要注意，以前曾经记录过这样一个案例:oracle诊断案例-spfile案例一则
5.等待原undo表空间所有undo segment offline sql> 0select usn,xacts,status,rssize/1024/1024/1024,hwmsize/1024/1024/1024,shrinks
2 from v$rollstat order by rssize.
usn xacts status rssize/1024/1024/1024 hwmsize/1024/1024/1024 shrinks
---------- ---------- --------------- --------------------- ---------------------- ----------
14 0 online .000114441 .000114441 0
19 0 online .000114441 .000114441 0
11 0 online .000114441 .000114441 0
12 0 online .000114441 .000114441 0
13 0 online .000114441 .000114441 0
20 0 online .000114441 .000114441 0
15 1 online .000114441 .000114441 0
16 0 online .000114441 .000114441 0