ORA-600:[no Guard Col] While Running Analyze Compute Statistics (Doc ID 1987981.1)

Last updated on FEBRUARY 11, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

Below error is encountered when running analyze compute statistics or estimate statistics on a table:

ORA-00600: [no guard col], [22], [172090], [], [], [], [], [], [], [], [],


The trace file shows details like below:

----- Current SQL Statement for this session (sql_id=a7wnfydmju7r2) -----
ANALYZE TABLE cenexplo COMPUTE STATISTICS

----- Call Stack Trace -----

... qkexrXformOpn_ModvC qkexrXformOpn_Col qkexrXformOpn qkexrXformOpn_Opt qkexrXformOpn qkxrXformOpn kknCodeGen opitca kksLoadChild kxsGetRuntimeLock kksfbc kkspsc0 kksParseCursor opiosq0 kpoal8 opiodr ...

 
Running the analyze statement with 'validate structure' does not fail with same error.

Statistics can be collected without any issue using dbms_stats procedure.

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