Streams Capture process is paused for flow control. Alert log shows ORA-4031 ("streams pool","unknown object","streams pool","sob_kgqmrec")" followed by ORA-600[4450
适用于:
Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later [Release: 10.2 and later ]
本文档的信息适用于任何平台。
描述:
Streams Capture process is paused for flow control.
alert日志显示的错误如下:
ORA-4031 "unable to allocate 136 bytes of shared memory ("streams pool","unknown object","streams pool","sob_kgqmrec")"
相关错误:
ORA-00600: internal error code, arguments: [4450], [], [], [], [], [], [], []
原因:
数据库初始化参数streams_pool_size被设置为1073741824 bytes,按 ORA-4031所说,参数值过小。
解决方案:
将streams_pool_size增加到一个更大的值,比如1.5G。