ORA-07445 [kggdlRemEle()+68] On Create Table Statement
(Doc ID 2203367.1)
Last updated on JUNE 14, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle 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.
Symptoms
On : 12.1.0.2 version, Internals Errors (ORA-600 & ORA-7445)
When executing the create table
CREATE TABLE <TABLE_NAME>
COMPRESS FOR OLTP
TABLESPACE <TABLESPACE_NAME>
RESULT_CACHE (MODE DEFAULT)
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
PARTITION BY RANGE (<COLUMN1>)
INTERVAL( 100)
SUBPARTITION BY HASH (<COLUMN2>)
SUBPARTITION TEMPLATE
......
NOCACHE
PARALLEL 32
MONITORING
ENABLE ROW MOVEMENT
as
select * from <TABLE_NAME>
the following error occurs.
ERROR
-----------------------
ORA-07445: exception encountered: core dump [kggdlRemEle()+68] [SIGSEGV] [ADDR:0x20] [PC:0x3B63674] [Address not mapped to object] []
ORA-10388: parallel query server interrupt (failure)
----- Call Stack Trace -----
.... kggdlRemEle <- kdblChangeSlotState <- kcblsod <- kss_del_cb <- kssdel <- kssdch_int <- kssdch <- kksumc ....
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |