My Oracle Support Banner

ADSTATS.SQL FAILS On 12.1.3 With ORA-20011 ORA-00600: internal error code, arguments: [1350] On V$NLS_VALID_VALUES (Doc ID 2044698.1)

Last updated on JULY 06, 2020

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


E-Business Suite R12 Applications Technology Stack, Database for Applications Technology related issues







Running adstats as sys / sysdba fails with ORA-20011 (Ref. <Note 1058763.1> - Step 25):

--- adstats.sql started at 2015-06-17 08:50:36 ---

Checking for the DB version and collecting statistics ...

ERROR at line 1:
ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments:
[1350], [1], [23], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_STATS", line 25335
ORA-06512: at "SYS.DBMS_STATS", line 25877
ORA-06512: at line 3
ORA-06512: at line 33

Disconnected from Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options


Looking at V$NLS_VALID_VALUES shows as,

SQL> select count(*) from V$NLS_VALID_VALUES;
select count(*) from V$NLS_VALID_VALUES
ERROR at line 1:
ORA-00600: internal error code, arguments: [1350], [1], [23], [], [], [], [],
[], [], [], [], []"

The issue can be reproduced via the following steps:
1. ran adstats.sql failed with error
2. V$NLS_VALID_VALUES showed internal error code


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

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