My Oracle Support Banner

ORA-600[kghfrh1] Errors When Gathering DBMS Stats (Doc ID 735337.1)

Last updated on OCTOBER 22, 2008

Applies to:

Oracle Server - Enterprise Edition - Version:
This problem can occur on any platform.


The following errors are reported in the alert.log:

     ORA-00600: internal error code, arguments: [kghfrh1], [0x000000000], [], [], [], [], [], []

There may be a current SQL reported in the trace file:


select /*+ no_parallel(t) no_parallel_index(t) dbms_stats
           cursor_sharing_exact use_weak_name_resl dynamic_sampling(0)
           no_monitoring */ count(*)
from ...


The call stack will resemble:

     kghnerror <- kghfrh_internal <- kghfrh <- kxsFreePersistentHe <- kxsCloseXsc <- kksCloseCursor
     <- opicca <- opiclo <- opicls

The error can be triggered when trying to run GATHER_STATS_JOB.


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

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.