本帖最后由 saup007 于 2012-5-28 15:38 编辑
create undo tablespace UNDOTBS1 DATAFILE '/u02/oradata/SID/undotbs01.dbf' SIZE 1G REUSE AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED;
alter system set undo_tablespace=UNDOTBS1 scope=both;
select usn,xacts,status,rssize/1024/1024/1024,hwmsize/1024/1024/1024,shrinks from v$rollstat order by rssize;
drop tablespace UNDOTBS2 including contents and datafiles;
空间并没有释放
$ /usr/sbin/lsof | grep undotbs02 其他的spid已经查询,不是后台进程,也不是active进程现在有一个进程为后台进程不能kill,怎么处理:
$ /usr/sbin/lsof | grep undotbs02
oracle 9684 oracle 19uREG104,6 24589115392 12730369 /u02/oradata/WENDING/undotbs02.dbf (deleted)
$ ps -ef | grep 9684
oracle8752 287090 15:33 pts/800:00:00 grep 9684oracle9684 102011 ?00:01:51 ora_q002_WENDING
|