在做EBS 跨平台迁移时，有一个步骤如下:
取消统计信息自动收集
从源应用服务器上拷贝$APPL_TOP/admin/adstats.sql到目标数据库端，以SYSDBA连接到sqlplus, 使用下面的命令重新启动数据库为 restricted 模式，运行 adstats.sql 脚本 ：
$ sqlplus "/ as sysdba"
SQL> alter system enable restricted session;
SQL> @adstats.sql
$ sqlplus "/ as sysdba"
SQL> alter system disable restricted session;
SQL> exit;
结果运行报错：
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 24867
ORA-06512: at “SYS.DBMS_STATS”, line 25408
查询可能有如下几个原因：
A Solution :
echo $ORA_NLS10
export ORA_NLS10=$ORACLE_HOME/nls/data/9idata
查询发现 ORA_NLS10设置正确 。
继续查询metalink , 发现是一个未发布的bug - DBMS_STATS.GATHER_FIXED_OBJECTS_STATS Fails With ORA-600 [1350], [1], [23] (文档 ID 1138205.1)
Cause
This is caused by unpublished Bug:9056912 - GATHERING STATISTICS ON EXTERNAL TABLES REQUIRES NULL FOR ESTIMATE_PERCENT
See Note:9056912.8 for an overview
Bug:9056912 is fixed in RDBMS 11.2.0.2 and 12.1 (Future Release).
Solution
To implement a solution for Bug:9056912, please execute any of the below alternative solutions:
•Upgrade to 11.2.0.2
OR
•Download and apply interim Patch:9056912, if available for your platform. and RDBMS release.
To check for conflicting patches, please use the MOS Patch Planner Tool.
OR
•Use the workaround with specify null for estimate_percent when collecting stats for an external table using gather_table_stats.
从源应用服务器上拷贝$APPL_TOP/admin/adstats.sql到目标数据库端，以SYSDBA连接到sqlplus, 使用下面的命令重新启动数据库为 restricted 模式，运行 adstats.sql 脚本 ：
$ sqlplus "/ as sysdba"
SQL> alter system enable restricted session;
SQL> @adstats.sql
$ sqlplus "/ as sysdba"
SQL> alter system disable restricted session;
SQL> exit;
结果运行报错：
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 24867
ORA-06512: at “SYS.DBMS_STATS”, line 25408
查询可能有如下几个原因：
A Solution :
echo $ORA_NLS10
export ORA_NLS10=$ORACLE_HOME/nls/data/9idata
查询发现 ORA_NLS10设置正确 。
继续查询metalink , 发现是一个未发布的bug - DBMS_STATS.GATHER_FIXED_OBJECTS_STATS Fails With ORA-600 [1350], [1], [23] (文档 ID 1138205.1)
Cause
This is caused by unpublished Bug:9056912 - GATHERING STATISTICS ON EXTERNAL TABLES REQUIRES NULL FOR ESTIMATE_PERCENT
See Note:9056912.8 for an overview
Bug:9056912 is fixed in RDBMS 11.2.0.2 and 12.1 (Future Release).
Solution
To implement a solution for Bug:9056912, please execute any of the below alternative solutions:
•Upgrade to 11.2.0.2
OR
•Download and apply interim Patch:9056912, if available for your platform. and RDBMS release.
To check for conflicting patches, please use the MOS Patch Planner Tool.
OR
•Use the workaround with specify null for estimate_percent when collecting stats for an external table using gather_table_stats.
本文转自ITPUB博客tolywang的博客，原文链接：ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments，如需转载请自行联系原博主。
