Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-04030 during logminer ?

626479Sep 1 2008 — edited Sep 2 2008

SQL> EXECUTE dbms_logmnr.add_logfile('/d/db/app/oracle/admin/oss/arc/arch1_42593.dbf', dbms_logmnr.new);

PL/SQL procedure successfully completed.

SQL> exec sys.dbms_logmnr.start_logmnr( Options => sys.dbms_logmnr.DICT_FROM_ONLINE_CATALOG );

PL/SQL procedure successfully completed.

SQL> SQL> select count(*) from v$logmnr_contents;
select count(*) from v$logmnr_contents
*
ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 408 bytes (T-LCR
structs,krvuinl_InitNewLcr)

any hints ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 30 2008

Added on Sep 1 2008

#general-database-discussions

4 comments

839 views