ANALYZE TABLE Fails With ORA-600 [kghfrh:ds], ORA-600 [kghfrempty:ds] And ORA-600 [17147] (Doc ID 884223.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.
***Checked for relevance on 19-Jun-2013***

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]


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


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


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:
create table tc_tab (col number);
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;
ANALYZE TABLE command will fail with memory corruptional errors (as described above):
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

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