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

Last updated on JUNE 13, 2013

Applies to:

Oracle Database - Standard Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
** Checked for relevance 30 January 2013 **

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:

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

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