ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments
在做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.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-773982/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-00600: internal error code, arguments: [kpnatdm】Error
- ORA-00600: internal error code, arguments: [525]Error
- ORA-00600: internal error code, arguments: [4194]Error
- ORA-00600: internal error code, arguments: [15753]Error
- ORA-00600: internal error code, arguments: [17087]Error
- ORA-00600: internal error code, arguments: [Cursor not typechecked],Error
- ORA-00600: internal error code, arguments: [32695]Error
- ORA-00600: internal error code, arguments: [kcbgtcr_13], [], [],Error
- ORA-00600: internal error code, arguments: [2662], [0],Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnCloseError
- 轉載:ORA-00600: internal error code, arguments: [504]Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose]Error
- ORA-00600: internal error code, arguments: [15709]Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [],[], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], [], [], [], []ErrorIndex
- ORA-00600: internal error code, arguments: [krvxbpns01], [], [], [], [], [],Error
- ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []Error
- ORA-00600 : internal error code, arguments: [qertbFetchByRowID]Error
- ORA-00600: internal error code, arguments: [2131], [9], [8]Error
- ORA-00600: internal error code, arguments: [13011]Error
- 案例ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], []ErrorIndex
- ORA-00600: internal error code, arguments: [kssadd: null parent]ErrorNull
- ora-00600:internal error code,arguments:[4194],[7],[2],[],[]Error
- ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [729], [4280], [space leak]Error
- ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [ErrorAST
- ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],ErrorAST
- ORA-00600: internal error code, arguments: [ksuinfos_modact1]ErrorUI
- ORA-00600: internal error code, arguments: [4194], [4], [31]Error
- ORA-00600: internal error code, arguments: [2103]錯誤Error
- ORA-00600: internal error code, arguments: [kcbgtcr_12], [4]Error
- ORA-00600: internal error code, arguments: [4194], [30], [30], [],Error
- ORA-00600: internal error code, arguments: [knacpft_ProcessFetchedTxns250]Error
- ORA-00600: internal error code, arguments: [qosdExpStatRead: expcnt mismatch], [Error
- ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46]Error
- ORA-00600: internal error code, arguments: [12235], [], [], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [ktecgeb-2], (一)Error
- ORA-00600: internal error code, arguments: [kcblasm_1], [103], []ErrorASM