My Oracle Support Banner

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

Last updated on JULY 30, 2019

Applies to:

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


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


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.