ORACLE UNDO表空间回收处理
1、首先查询当前undo表空间的使用情况
SQL> select file_name,bytes/1024/1024 MB,autoextensible from dba_data_files where tablespace_name like 'UNDOTBS1';
FILE_NAME MB AUTOEX
---------------------------------------------------------------------------------------------------- ---------- ------
+MGMT/_MGMTDB/76C3BF7AF221EFDFE0530F0B08BCEB76/DATAFILE/undotbs2.285.1034609595 2048 NO
2、查看当前undo的参数
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
temp_undo_enabled boolean FALSE
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS2
3、切换undo表空间
SQL>alter system set undo_tablespace=undotbs2 scope=both;
SQL> show parameter undo
NAME TYPE VALUE
-------------