ORA-07445 [qksdsInitSample()+653] [SIGFPE] [Integer divide by zero] (Doc ID 1136428.1)

Last updated on FEBRUARY 07, 2014

Applies to:

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

Symptoms

Error reported in the alert log:

Exception [type: SIGFPE, Integer divide by zero] [ADDR:0x4A947ED] [PC:0x4A947ED, qksdsInitSample()+653] [flags: 0x0, count: 1]
ORA-07445: exception encountered: core dump [qksdsInitSample()+653] [SIGFPE] [ADDR:0x4A947ED] [PC:0x4A947ED] [Integer divide by zero] []

Failing SQL:
/* SQL Analyze(323,1) */ select .....

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object             line             object
handle              number      name
0x25b8c1fb0   11774 package body SYS.DBMS_SQLTUNE_INTERNAL
0x255259a30   7          SYS.WRI$_ADV_SQLTUNE
0x25b926de0   545    package body SYS.PRVT_ADVISOR
0x25b926de0   2613   package body SYS.PRVT_ADVISOR
0x257ab1478   241    package body SYS.DBMS_ADVISOR
0x257ade038    772   package body  SYS.DBMS_SQLTUNE
0x25ae57d60    4        anonymous block

Top Call Stack:
qksdsInitSample qksdsExecute qsmmixGenSampledVColStats qsmmixFindOrCreateVirtualCol qsmmixCheckIdxOpn qsmmixCheckBitmapPred

Cause

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