oracle 调整 undo 表空间大小

创建并设置新的undo表空间
create undo tablespace undotbs02datafile '/home/oradata/mydb/undotbs201.dbf' size 1500M reuse AUTOEXTEND ON;
alter system set undo_tablespace=undotbs02;

select usn,xacts,status,rssize/1024/1024/1024,hwmsize/1024/1024/1024,shrinks from v$rollstat order by rssize;

删除原UNDO表空间
alter tablespace undotbs01 offline
drop tablespace undotbs1 including contents and datafiles;

表空间增加数据文件方法
ALTER TABLESPACE undotbs02 ADD DATAFILE '/home/oradata/mydb/undotbs202.dbf' size 1500M reuse AUTOEXTEND ON;