My Oracle Support Banner

DBMS_STATS.GATHER_TABLE_STATS fails with ORA-20011 ORA-600 [Kghsrs_printf:Len] (Doc ID 741560.1)

Last updated on MARCH 27, 2019

Applies to:

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

Symptoms

You are gathering statistics on a table

For example:

Changes

The table has a function based index and the problem can be reproduced in 11.1.0.6 by a simple testcase:

1) Create Table

2) Create functional index

3) Insert

4) exec dbms_stats.gather_table_stats(USER,'NAME',cascade=>TRUE);

However, the problem does not occur in 11.1.0.7.

Also, if the index is dropped, the problem does not occur. 

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.