当undo表空间满的情况下,我们切换了undo空间后,但该空间还是处理100%状态,如果不想让他100%,有没有活动事物的情况下.我们可以采用如下方式,对回滚段进行删除操作.来达到释放空间的作用.
1.alter system set "_smu_debug_mode" = 4 scope = memory sid='';
2.select 'alter rollback segment "' || s.segment_name || '" offline;'
from dba_rollback_segs s
where s.tablespace_name <> 'SYSTEM'
and s.tablespace_name = 'UNDO1' and s.status = 'OFFLINE';
3、select 'drop rollback segment "' || s.segment_name || '";'
from dba_rollback_segs s
where s.tablespace_name <> 'SYSTEM'
and s.tablespace_name = 'UNDO1' and s.status = 'OFFLINE';
4.alter system set "_smu_debug_mode" = 0 scope = memory sid='oyy1a';
1.alter system set "_smu_debug_mode" = 4 scope = memory sid='';
2.select 'alter rollback segment "' || s.segment_name || '" offline;'
from dba_rollback_segs s
where s.tablespace_name <> 'SYSTEM'
and s.tablespace_name = 'UNDO1' and s.status = 'OFFLINE';
3、select 'drop rollback segment "' || s.segment_name || '";'
from dba_rollback_segs s
where s.tablespace_name <> 'SYSTEM'
and s.tablespace_name = 'UNDO1' and s.status = 'OFFLINE';
4.alter system set "_smu_debug_mode" = 0 scope = memory sid='oyy1a';
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29446986/viewspace-1307321/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29446986/viewspace-1307321/