OGG director 显示进程挂起查看进程dsc文件，发现报 ORA-01654，此类问题一般是由于index的next_extent 过大造成的，但是查询相关视图后发现并不是这个原因造成的。由此猜想是不是磁盘空间不足导致的：

[php]

ASMCMD> lsdg
State   Type   Rebal Unbal Sector Block AU      Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name
MOUNTED EXTERN N     N     512    4096  1048576 204800   204543  0               204543         0 INTER_ARC/
MOUNTED EXTERN N     N     512    4096  1048576 512000   43      0               43             0 INTER_DATA/
MOUNTED EXTERN N     N     512    4096  1048576 204800   201797  0               201797         0 NGPSS_ARC/
MOUNTED EXTERN N     N     512    4096  1048576 1843200  628084  0               628084         0 NGP_DATA/

[/php]

可以看出磁盘空间不足导致index无法扩展。
此时需要释放空间，首先想到UNDO空间

[php]
–创建undo表空间
CREATE UNDO TABLESPACE undo01 DATAFILE ‘+INTER_DATA/pg90101/datafile/undo01.dbf’ SIZE 10m AUTOEXTEND ON NEXT 10m;
CREATE UNDO TABLESPACE undo01 DATAFILE ‘+INTER_DATA/pg90101/datafile/undo01.dbf’ SIZE 10m AUTOEXTEND ON NEXT 10m;
–修改系统undo
alter system set undo_tablespace=’undo01′ scope=spfile sid=’pg901011′;
alter system set undo_tablespace=’undo02′ scope=spfile sid=’pg901011′;
–删除undo
drop tablespace undotbs1 INCLUDING CONTENTS AND DATAFILES;
drop tablespace undotbs2 INCLUDING CONTENTS AND DATAFILES;
–扩大undo
ALTER DATABASE DATAFILE ‘+INTER_DATA/pg90101/datafile/undo01.dbf’ RESIZE 5G;
ALTER DATABASE DATAFILE ‘+INTER_DATA/pg90101/datafile/undo02.dbf’ RESIZE 5G;
[/php]