今天使用LogMiner找回误更新的数据时,查询v$logmnr_contents时,遇到了“ORA-04030: out of process memory when trying to allocate 152 bytes (Logminer LCR c,krvtadc)”错误。查了一下My Oracle Support,发现出现ORA-04030错误的原因,特摘录在此。 如果指定了COMMITTED_DATA_ONLY选项而且发出了查询,则LogMiner会...
ERROR at line 2: ORA-4030: out of process memory when trying to allocate 56 bytes (Logminer LCR c,krvtadc) CAUSE According to the documentation in Oracle® Database Utilities: If the COMMITTED_DATA_ONLY option is specified and you issue a query, LogMiner stages all redo records within a...
ORA-4030: out of process memory when trying to allocate 56 bytes (Logminer LCR c,krvtadc) CAUSE According to the documentation in Oracle® Database Utilities: If the COMMITTED_DATA_ONLY option is specified and you issue a query, LogMiner stages all redo records within a single transaction ...
LOGMINER: Begin mining logfile for session -2147289087 thread 2 sequence 2775, +DATA/DB/ONLINELOG/redo10a.log 2023-09-24T19:59:02.696407+08:00 Errors in file /u01/app/oracle/diag/rdbms/db/db1/trace/db1_s013_26788.trc (incident=1955417): ORA-04030: out of process memory when trying t...
今天使用LogMiner找回误更新的数据时,查询v$logmnr_contents时,遇到了“ORA-04030: out of process memory when trying to allocate 152 bytes (Logminer LCR c,krvtadc)”错误。查了一下My Oracle Support,发现出现ORA-04030错误的原因,特摘录在此。