oracle 回收undo,ORACLE UNDO表空间回收处理

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

-------------