oracle表空间－－－undo表空间切换

--undo 表空间  剩余
select (a.all_bytes - b.busy_bytes) / 1024 / 1024
  from (SELECT SUM(BYTES) all_bytes
          FROM DBA_DATA_FILES
         WHERE TABLESPACE_NAME = 'UNDOTBS2') a,
       (SELECT NVL(SUM(BYTES), 0) busy_bytes
          FROM DBA_UNDO_EXTENTS
         WHERE TABLESPACE_NAME = 'UNDOTBS2'
           AND STATUS IN ('ACTIVE', 'UNEXPIRED')) b;
--创建undo表空间
create undo tablespace undotbs3 datafile 'xxxx' size xxxxM;
--扩展undo表空间
alter tablespace undotbs3  add datafile 'xxxx' size xxxxM;
--查询数据库实例
select instance_name from v$instance; -->查实例名
--查看现在用的undo的名字
show parameter undo;
--修改undo为新的undo
alter system set undo_tablespace=undotbs3 scope=both sid='查出来的实例名';
--查看是否修改成功
show parameter undo;