Oracle 11g数据库中出现执行过长SQL语句导致执行报错
王秀珩
738次浏览
编辑于2018年07月24日 14:10:28
所属模块系统性能
适用版本EAS 6.0, EAS 7.0.1, EAS 7.0.2及之后版本
问题描述Oracle 11g数据库中出现执行过长SQL语句，导致执行报ORA-00600的错误，应用执行中断。(当前问题出现的环境: AIX系统+ORACLE 11.2.0.1)具体报错信息如下所示：Dump continued from file:/u01/app/diag/rdbms/ctsdb/ctsdb2/trace/ctsdb2_ora_323642.trcORA-00600: internal error code, arguments:[kkqcscpopn_Int: 0], [], [], [], [], [], [], [], [], [], [], [] ========= Dump for incident 114665 (ORA 600[kkqcscpopn_Int: 0]) ========*** 2010-09-03 16:54:36.935dbkedDefDump(): Starting incident defaultdumps (flags=0x2, level=3, mask=0x0)----- Current SQL Statement for thissession (sql_id=dn25x3r0szxha) -----INSERT INTO VTIAMEQV2FSQO5WO423DJ9L7Y3(FAccountID, FCurrencyID, FYearBeginDebitFor, FYearBeginCreditFor,FBeginDebitFor, FBeginCreditFor, FDebitFor, FCreditFor, FYearDebitFor,FYearCreditFor, FEndDebitFor, FEndCreditFor, FYearBeginDebitLocal, ...........
适用版本EAS 6.0, EAS 7.0.1, EAS 7.0.2及之后版本
问题描述Oracle 11g数据库中出现执行过长SQL语句，导致执行报ORA-00600的错误，应用执行中断。(当前问题出现的环境: AIX系统+ORACLE 11.2.0.1)具体报错信息如下所示：Dump continued from file:/u01/app/diag/rdbms/ctsdb/ctsdb2/trace/ctsdb2_ora_323642.trcORA-00600: internal error code, arguments:[kkqcscpopn_Int: 0], [], [], [], [], [], [], [], [], [], [], [] ========= Dump for incident 114665 (ORA 600[kkqcscpopn_Int: 0]) ========*** 2010-09-03 16:54:36.935dbkedDefDump(): Starting incident defaultdumps (flags=0x2, level=3, mask=0x0)----- Current SQL Statement for thissession (sql_id=dn25x3r0szxha) -----INSERT INTO VTIAMEQV2FSQO5WO423DJ9L7Y3(FAccountID, FCurrencyID, FYearBeginDebitFor, FYearBeginCreditFor,FBeginDebitFor, FBeginCreditFor, FDebitFor, FCreditFor, FYearDebitFor,FYearCreditFor, FEndDebitFor, FEndCreditFor, FYearBeginDebitLocal, ...........
推荐阅读