dbms_logmnr.start_logmnr terminates due to ORA-04030. (Doc ID 1066640.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.1.0.7 - Release: 11.1 to 11.1
Information in this document applies to any platform.

Symptoms


ORA-04030: out of process memory when trying to allocate 88136 bytes (krvdctab,KRVD:halc)
...

----- Current SQL Statement for this session (sql_id=cfb235mw7b08w) -----
begin
dbms_logmnr.start_logmnr(options => 268435456,
DictFileName => '/u01/app/oracle/diag/rdbms/testdb/testdb/ir/offline_dictionary.ir');
end;

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
7000000492e0d40 58 package body SYS.DBMS_LOGMNR
7000000492e2cc8 2 anonymous block


STACK
-----
[07]: kghnospc [KGH]<-- Signaling
[08]: kghalo [KGH]
[09]: krvualmfh []
[10]: krvdhalc []
[11]: krvdsrv []
[12]: krvdgnrow []
[13]: krvdtrowi []
[14]: krvdpcmd []
[15]: krvdcat []
[16]: krvdload []


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms