首页 > 学术百科

ORA-00600内部错误代码,参数[19004]

tf2o

ORA-00600内部错误代码，参数[19004]

数据库版本：Oracle 11.2.0.1.0

数据库服务器操作系统：Windows server 2008

问题现象：业务⼈员在前台执⾏某些查询操作时，报错ORA-00600: 内部错误代码, 参数: [19004]；

解决⽅案：查看alert警告⽇志，查对应的trace⽂件，到触发此bug的sql语句如下：

----- Current SQL Statement for this session (sql_id=.......) -----

SELECT *

FROM TAB_1

湖南卫视晚间新闻WHERE COL_1 in (select id from TAB_2)

and COL_2 in (:1, :2)

and COL_3 in

('null', 'null', 'null', 'null', 'null', 'null', 'null')

order by COL_4,COL_5;

根据MOS查看，此错误匹配多个BUG，都是由于表错误的统计信息和列的统计直⽅图触发此BUG，可以删除SQL中对应表的统计信息和统计直⽅图临时解决此问题，或者直接升级数据库跳过此BUG；

删除统计信息⽅法如下：

秦皇岛pm2.5散打狼执⾏了这⾯这条语句后就可以了

---ANALYZE TABLE TAB_1 DELETE STATISTICS;

---ANALYZE TABLE TAB_2 DELETE STATISTICS;

SQL> execute dbms_stats.delete_table_stats(ownname=>'USER_NAME',tabname=>'TAB_1');

SQL> execute dbms_stats.delete_table_stats(ownname=>'USER_NAME',tabname=>'TAB_2');

SQL> execute dbms_stats.lock_table_stats(ownname=>'USER_NAME',tabname=>'TAB_1');

SQL> execute dbms_stats.lock_table_stats(ownname=>'USER_NAME',tabname=>'TAB_2');

---SQL> execute dbms_stats.unlock_table_stats(ownname=>'USER_NAME',tabname=>'TAB_1');

---SQL> execute dbms_stats.unlock_table_stats(ownname=>'USER_NAME',tabname=>'TAB_2');

删除表统计信息可能会⽣成错误的执⾏计划，影响SQL执⾏效率；

可以适当调⼤动态取样级别；

SQL> show parameter optimizer_dynamic_sampling

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

optimizer_dynamic_sampling integer 4

其中MOS中查询有关ORA-00600[19004]问题相关信息；

ORA-600 [19004] (⽂档 ID 138652.1)

Note: For additional ORA-600 related information please read

PURPOSE:

This article represents a partially published OERI note.

It has been published because the ORA-600 error has been

reported in at least one confirmed bug.

Therefore, the SUGGESTIONS section of this article may help江西省城乡建设培训中心

in terms of identifying the cause of the error.

This specific ORA-600 error may be considered for full publication

at a later date. If/when fully published, additional information

will be available here on the nature of this error.

SUGGESTIONS:法制与社会发展

If the Known Issues section below does not help in terms of identifying

a solution, please submit the trace files and alert.log to Oracle

Support Services for further analysis.

Known Issues:

You can restrict the list below to issues likely to affect one of the following versions by clicking the relevant button:

The list below is restricted to show only bugs believed to affect version 11.2.0.1.

Other bugs may affect this version but have not been confirmed as being relevant yet.

There are 6 bugs listed.

NB Prob Bug Fixed Description

II12.1.0.2, 12.2.0.0ORA-600 [19004] when stats have been gathered with NLS_SORT / NLS_COMP not default BINARY II11.2.0.4, 12.1.0.1Manually setting column stats cannot exceed 4Gb max size

III12.1.0.2, 12.2.0.0ORA-600 [19004] or inaccuracies on join of histogrammed columns

III11.2.0.3, 12.1.0.1Allow optimizer to bypass corrupt histogram data

扬大附小III11.2.0.2, 12.1.0.1Query optimization fails with OERI[19004]

E II11.2.0.2, 12.1.0.1Enh: allow extended and adaptive cursor sharing to support LIKE predicates

· '*' indicates that an alert exists for that issue.

· '+' indicates a particularly notable issue / bug.

· See for details of other symbols used

本文发布于:2024-09-25 02:30:26，感谢您对本站的认可！

本文链接：https://www.17tex.com/xueshu/212358.html

上一篇：UG编程报警【内部错误：内存访问违例】怎么处理？

下一篇：ORA-00600：内部错误代码

标签：统计信息问题

留言与评论（共有 0 条评论）