ANALYZE TABLE Fails With ORA-600 [kghfrh:ds], ORA-600 [kghfrempty:ds] And ORA-600 [17147]
(Doc ID 884223.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.1.0.7 [Release 11.1]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.
Symptoms
ANALYZE TABLE ... COMPUTE STATISTICS fails with memory corruptional errors such as:
ORA-00600 [kghfrh:ds], ORA-00600 [kghfrempty:ds] and ORA-00600 [17147]
- OR -
ORA-07445: [memmove()+184] [SIGSEGV]
- OR -
ORA-07445: [memmove()+184] [SIGSEGV]
The generated trace file shows that the error is reported while selecting from ecol$:
----- Current SQL Statement for this session (sql_id=aa35g82k7dkd9) -----
select binaryDefVal, length(binaryDefVal) from ecol$ where tabobj# = :1 and colnum = :2
select binaryDefVal, length(binaryDefVal) from ecol$ where tabobj# = :1 and colnum = :2
The call stack trace is similar to:
skdstdst ksedst1 ksedst dbkedDefDump ksedmp ksfdmp dbgexPhaseII dbgexExplicitEndInc
dbgeEndDDEInvocationImpl dbgeEndDDEInvocation kghnerror kgh_heap_sizes kkoDumpHeapSize
kkoStateDump qksctxDump kxsDump1 kxsDump kxsDumpCursor kxsDumpCursors curdmp ksudps
dbkedDefDump ksedmp ksfdmp dbgexPhaseII dbgexExplicitEndInc dbgeEndDDEInvocationImpl
dbgeEndDDEInvocation kghnerror kghfrempty kghgex kghalf ktiNonImuPoolAllocate ktiTxnPoolAllocate
ktcxbr0 qoshsavcuris kdasti kdasts kkndgd kknls kkndrv opiexe opiosq0 kpooprx kpoal8 opiodr ttcpip opitsk
opiino opiodr opidrv sou2o opimai_real opimai OracleThreadStart@4
dbgeEndDDEInvocationImpl dbgeEndDDEInvocation kghnerror kgh_heap_sizes kkoDumpHeapSize
kkoStateDump qksctxDump kxsDump1 kxsDump kxsDumpCursor kxsDumpCursors curdmp ksudps
dbkedDefDump ksedmp ksfdmp dbgexPhaseII dbgexExplicitEndInc dbgeEndDDEInvocationImpl
dbgeEndDDEInvocation kghnerror kghfrempty kghgex kghalf ktiNonImuPoolAllocate ktiTxnPoolAllocate
ktcxbr0 qoshsavcuris kdasti kdasts kkndgd kknls kkndrv opiexe opiosq0 kpooprx kpoal8 opiodr ttcpip opitsk
opiino opiodr opidrv sou2o opimai_real opimai OracleThreadStart@4
The issue occurs under the following circumstances:
Instance parameter COMPATIBLE is set to 11.0.0 (or higher).
After adding two or more columns with specified default values to a table, similar to below steps:
After adding two or more columns with specified default values to a table, similar to below steps:
create table tc_tab (col number);ANALYZE TABLE command will fail with memory corruptional errors (as described above):
alter table tc_tab add col2 number(4,2) default 0 not null;
alter table tc_tab add col3 number(4,2) default 0 not null;
alter table tc_tab add col4 number(4,2) default 0 not null;
SQL>ANALYZE TABLE <schema>.tc_tab COMPUTE STATISTICS;
Changes
Prior to ANALYZE TABLE, two or more columns were added to the table with default value specified.
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 |