My Oracle Support Banner

ORA-07445 Mining a 10g archive With Logminer 11g (Doc ID 1603298.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2]
Information in this document applies to any platform.


Mining an Oracle 10g archive with the Oracle DBMS_LOGMNR package fails with an ORA-7445 [krvtgsupd_GenStmtUpdate()+313]

The alert logfiles shows errors like:

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x44] [PC:0x53E4CC5, krvtgsupd_GenStmtUpdate()+313] [flags: 0x0, count: 1]
Errors in file /home/ora11g/diag/rdbms/.../.../<SID>_ora_10593.trc  (incident=30223):
ORA-07445: exception encountered: core dump [krvtgsupd_GenStmtUpdate()+313] [SIGSEGV] [ADDR:0x44] [PC:0x53E4CC5] [Address not mapped to object] []
Incident details in: /home/ora11g/diag/rdbms/.../.../incident/incdir_30223/<SID>_ora_10593_i30223.trc
Use ADRCI or Support Workbench to package the incident.

In the tracefile, the following information is shown:

FROM "SYS"."V$LOGMNR_CONTENTS" WHERE (seg_owner=:schema and seg_name=:tab) or (OPERATION in ('COMMIT','ROLLBACK'))
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x25e2fa6d0        30  function <function_name>
0x25e4720d8        10  anonymous block

----- Call Stack Trace -----
krvtgsupd_GenStmtUpdate krvtgst krvfgsql_GenerateSql krvffar_FillAdhocRow krvfcact2 krvfcact qerfxFetch rwsfcd qerltcFetch
insexe opiexe opipls opiodr rpidrus skgmstack rpiswu2 rpidrv psddr0 psdnal pevm_EXIM pfrinstr_EXIM pfrrun_no_tool pfrrun
plsql_run peicnt kkxexe opiexe kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real main

Plan Table
| Id  | Operation                 | Name             | Rows  | Bytes | Cost  | Time      |
| 0   | INSERT STATEMENT          |                  |       |       |     1 |           |
| 1   |  LOAD TABLE CONVENTIONAL  |                  |       |       |       |           |
| 2   |   FIXED TABLE FULL        | X$LOGMNR_CONTENTS|     1 |  2352 |     0 |           |


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.