My Oracle Support Banner

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

Last updated on FEBRUARY 22, 2019

Applies to:

Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.


The alert log reports an error like:

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 ..

----- 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 ...





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.