一套HP-UX上的9.2.0.8系统,某条查询语句执行时出现ORA-00600: internal error code, arguments: [6033], [], [], [], [], [], [], []内部错误,错误trace信息如下:
*** SESSION ID:(583.18281) 2010-12-20 22:49:01.364 *** 2010-12-20 22:49:01.364 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [6033], [], [], [], [], [], [], [] Current SQL statement for this session: SELECT INTERFACE_HEADER_ID, DOCUMENT_SUBTYPE, AGENT_ID, VENDOR_SITE_ID FROM PO_HEADERS_INTERFACE WHE RE WF_GROUP_ID = :B1 ORDER BY INTERFACE_HEADER_ID ----- PL/SQL Call Stack ----- object line object handle number name c0000001067e3328 4332 package body APPS.PO_AUTOCREATE_DOC c0000000fd267060 1 anonymous block c000000108fe4d60 1979 package body APPS.WF_ENGINE_UTIL c000000108fe4d60 1745 package body APPS.WF_ENGINE_UTIL c000000108fe4d60 1099 package body APPS.WF_ENGINE_UTIL c000000108fe4d60 560 package body APPS.WF_ENGINE_UTIL c000000108fe4d60 1863 package body APPS.WF_ENGINE_UTIL c000000108fe4d60 1099 package body APPS.WF_ENGINE_UTIL c000000108fe4d60 560 package body APPS.WF_ENGINE_UTIL c000000108fe4d60 1863 package body APPS.WF_ENGINE_UTIL c000000108fe4d60 1099 package body APPS.WF_ENGINE_UTIL c000000108fe4d60 560 package body APPS.WF_ENGINE_UTIL c000000108fe4d60 1863 package body PL/SQL call stack truncated after 1024 bytes. ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- ksedmp()+184 ? ksedst() C0000000CEB36420 ? 400000000147994B ?已知的ORA-00600:[6033]错误一般和索引逻辑讹误相关,metalink上有相关的Note建议在出现该错误后运行analyze table validate structure cascade语句以验证表与索引间的数据正确性。
Index corruption.
本文转自maclean_007 51CTO博客,原文链接:
http://blog.51cto.com/maclean/1277679