ora-01341 logminer out of memory

今天一大早打开电脑 查看主库日志，发现大量错误ora-01341

ORA-01341: LogMiner out-of-memory
Thu May 10 07:16:49 2012
TLCR process death detected. Shutting down TLCR
Thu May 10 07:16:51 2012
Streams CAPTURE C001 with pid=27, OS id=30852 stopped
Thu May 10 07:16:51 2012
Errors in file /u01/oracle/admin/orcl/bdump/orcl_c001_30852.trc:
ORA-01280: Fatal LogMiner Error.

如果谨慎的话可以先停止次库的捕获进程

查看一下各流进程的状态

select capture_name,status from dba_capture;糟糕 abort.非正常停止。

select decode(process_type,1,'APPLY',2,'CAPTURE') process_name,
name, value
from sys.streams$_process_params
order by 1,2;

上面display只有10M，太小了吧

停止，加大流池大小为100M,启动，Ok
exec dbms_capture_adm.start_capture('CAPTURES_DEST');
exec dbms_capture_adm.set_parameter('CAPTURES_DEST','_SGA_SIZE','100');
exec dbms_capture_adm.start_capture('CAPTURES_DEST');

再查看

LOGMINER: Memory Size = 100M, Checkpoint interval = 10M
LOGMINER: session# = 43, reader process P002 started with pid=36 OS id=18878
LOGMINER: session# = 43, builder process P003 started with pid=37 OS id=18880
LOGMINER: session# = 43, preparer process P004 started with pid=39 OS id=18882
Thu May 10 09:25:28 2012
LOGMINER: Begin mining logfile: /u01/oracle/oradata/orcl/arch/arch1_176_780855407.arc
Thu May 10 09:25:28 2012
LOGMINER: End mining logfile: /u01/oracle/oradata/orcl/arch/arch1_176_780855407.arc
Thu May 10 09:25:28 2012