Oracle 10.2 流复制问题（四）—— ORA-01341: LOGMINER OUT-OF-MEMORY in Oracle Streams

系统配置：Linux CentOS 5、Oracle Enterprise Edition Release 10.2.0.1.0、表级单向流复制 问题现象：流复制失效，源表更新，目标表没有更新 排错过程：

1) 查看捕获进程状态 select capture_name,status from dba_capture;

Capture status 为ABORTED

2) 查看alert_<sid>.log krvxerpt: Errors detected in process 65, role builder. krvxmrs: Leaving by exception: 1341 ORA-01341: LogMiner out-of-memory LOGMINER: session#=42, builder MS01 pid=65 OS id=29684 sid=1018 stopped Streams CAPTURE CP01 for ####### with pid=62, OS id=29652 stopped ORA-01280: Fatal LogMiner Error.

3) 查看跟踪文件中的日志挖掘进程

Spill: can not find enough to spill. amountNeeded: 1993904 Session MaxMem 10485760, CacheSize 129264, MemSize 129264

4) 获得源库流复制参数 select decode(process_type,1,'APPLY',2,'CAPTURE') process_name, name, value from sys.streams$_process_params order by 1,2;

5) 在源库更改流复制的_SGA_SIZE参数

BEGIN
dbms_capture_adm.set_parameter(capture_name => 'CAPTURE1',
                               parameter  => '_SGA_SIZE',
                               VALUE      => '100');
END;
/