ORA-07445 [apaneg] or ORA-07445[kksSetBindType()+10830] Reported for SQL Analyze

(Doc ID 1942548.1)

Last updated on DECEMBER 22, 2017

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


The alert log reports an error like:

2014-10-18 10:14:49  Errors in file C:\APP\diag\rdbms\prsm\prsm\trace\prsm_j001_7376.trc  (incident=279894):
ORA-07445: exception encountered: core dump [apaneg()+134] [ACCESS_VIOLATION] [ADDR:0x8] [PC:0x1456E434A] [UNABLE_TO_READ] []

- or -

ORA-07445: exception encountered: core dump [kksSetBindType()+10830] [SIGSEGV] [ADDR:0x1389D410] [PC:0x200AFDE] [Address not mapped to ob
ORA-10980: prevent sharing of parsed query during Materialized View query generation

The trace shows the error related to a sql analyze statement with a pl/sql stack and call stack like:

*** 2014-10-16 22:05:40.904
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=dk030d8y5y2k2) -----
/* SQL Analyze(253,1) */ select * from (select rownum rwnum, dockey,verkey,docnum,ordernum,versionnum,doctype,subdoctypekey,doctypedescription,docdate,

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
00000002B57B57F8     11816  package body SYS.DBMS_SQLTUNE_INTERNAL
000000029C6AF2F0         7  SYS.WRI$_ADV_SQLTUNE
00000002B5B72120       587  package body SYS.PRVT_ADVISOR
00000002B5B72120      2635  package body SYS.PRVT_ADVISOR
00000002B675B5E0       241  package body SYS.DBMS_ADVISOR
00000002B6743EB0       821  package body SYS.DBMS_SQLTUNE
000000029C5C9C70         4  anonymous block

----- Call Stack Trace -----

... apaneg apasor kkoqbc apakkoqb apaqbdDescendents apaqbdList apaqbd kkqctCostTransfQB kkqctdrvSU kkqutruns kkqutruns kkqutruns kkqudrv kkqctdrvTD kkqdrv kkqctdrvIT apadrv opitca kksSetBindType kksfbc opiexe kpoal8 opiodr kpoodrc rpiswu2 kpoodr xupirtrc upirtrc kpurcsc kpuexec OCIStmtExecute qksanExecSql qksanAnalyzeSql qsmmixProcessQuery qsmmixSqlTuneAnalyzeIdx kestsiIndexAnalyzeDrv kestsTuneSqlDrv kesaiExecAction kesaiTuneSqlDrv ...



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