My Oracle Support Banner

ORA-07445 [Kttuser0()+439] [Int_divide_by_zero] After Creating a New Temporary Tablespace (Doc ID 1259393.1)

Last updated on APRIL 03, 2020

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Standard Edition - Version 11.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
NOTE: In the images and/or the document content below, the user information and data used represents fictitious data. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Symptoms

After creating a new temp tablespace on 11.2, the following error is reported in the alert.log:

ORA-07445: exception encountered: core dump [kttuser0()+439] [INT_DIVIDE_BY_ZERO] [] [PC:0x16ACFBB] [] []

The failing sql is an insert into a temporary table for the DBSNMP user:

INSERT INTO DBSNMP.MGMT_TEMPT_SQL(SQL_ID, HASH_VALUE, ELAPSED_TIME, EXECUTIONS) VALUES (:B4 , :B3 , :B2 , :B1 )

Stack trace is similar to the following:

kttuser0 ktatcreate kxttGetPh kxttICreate kctphTTCreate insSetExecTmpTabInf insini insExecStmtExecIniEngine
qerltcStart insexe opiexe opipls opiodr rpidrus rpidru rpiswu2 rpidrv psddr0 psdnal pevm_EXECC pfrinstr_EXECC
pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o
opimai_real opimai OracleThreadStart 0000000076DCF56D 0000000077003281

 

Cause

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
Symptoms
Cause
Solution


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