My Oracle Support Banner

ORA-600 [12807] & ORA-600 [kghssgdmp1] Errors Occurring When Gathering Statistics (Doc ID 1438757.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]
Information in this document applies to any platform.

Symptoms

You encounter ORA-600 [12807] errors possibly followed by ORA-600 [kghssgdmp1] errors when attempting to gather statistics on tables.  From the trace file generated the error occurs on execution of the CREATE GLOBAL TEMPORARY TABLE command with a call stack similar to the following:


kkdcnco kkdcico ctcdrv opiexe opiosq0 opipls opiodr rpidrus skgmstack rpidru rpiswu2 rpidrv psddr0 psdnal pevm_EXIM pfrinstr_EXIM pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real main __start



Changes

Statistics are being gathered with an estimate percentage of less than 30%.

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.