Reclaim undo tablespace

UNDO space recycling:
1 Confirm undo
Selectfile_name, bytes/1024/1024 fromdba_data_fileswheretablespace_namelike 'undotbs1 ';
2. Check the UNDOSegment status
3 selectusn, xacts, rssize/1024/1024/1024, hwmsize/1024/1024/1024, shrinksfromv $ rollstatorderbyrssize;
4. Create a New UNDO tablespace
Createundotablespaceundotbs2datafile '/oradata/mlq/undotbs02.dbf' size20M;
5. Switch the UNDO tablespace to the new UNDO tablespace.
Altersystemsetundo_tablespace = undotbs2scope = both;
6. wait for all the undosegmentofflines in the original UNDO tablespace.
Selectusn, xacts, status, rssize/1024/1024/1024, hwmsize/1024/1024/1024, shrinksfromv $ rollstatorderbyrssize;
7. Delete the original UNDO tablespace
Droptablespaceundotbs1includingcontents;
8. Check the space

Selecttablespace_name, sum (bytes)/1024/1024/second, sum (bytes)/1024/1024/1024GBfromdba_temp_filesgroupbytablespace_nameorderbyGB;

This article is from the "mlqiang" blog, please be sure to keep this source http://162234.blog.51cto.com/152234/1303270