ORA-00600:: [kkocxj : pjpCtx]错误

ops$admin@CRMG>explain plan for
  2  select trunc(avg(in8_call_duration), 2) as in8_call_duration,
  3         trunc(avg(out8_call_duration), 2) as out8_call_duration,
  4         id,
  5         name
  6    from (select distinct a.agent_id,
  7                          nvl(a.in8_call_duration, 0) as in8_call_duration,
  8                          nvl(b.out8_call_duration, 0) as out8_call_duration,
  9                          aue.login_id,
 10                          ao.name,
 11                          ao.id
 12            from (select vcr.agent_id,
 13                         trunc(sum(call_duration) / 3600, 2) in8_call_duration
 14                    from vodka.vdk_call_record vcr
 15                   where vcr.is_deleted = 'n'
 16                     and DIRECTION = 'OUT'
 17                     and vcr.gmt_create >=
 18                         to_date(to_char(TRUNC(SYSDATE), 'yyyy-mm-dd') ||
 19                                 '08:30:00',
 20                                 'yyyy-mm-dd hh24;mi:ss')
 21                     and vcr.gmt_create <=
 22                         to_date(to_char(TRUNC(SYSDATE), 'yyyy-mm-dd') ||
 23                                 '18:00:00',
 24                                 'yyyy-mm-dd hh24;mi:ss')
 25                     and vcr.CALL_DURATION is not null
 26                   group by vcr.agent_id) a,
 27                 (select vcr.agent_id,
 28                         trunc(sum(call_duration) / 3600, 2) out8_call_duration
 29                    from vodka.vdk_call_record vcr
 30                   where vcr.is_deleted = 'n'
 31                     and DIRECTION = 'OUT'
 32                     and (vcr.gmt_create <
 33                         to_date(to_char(TRUNC(SYSDATE), 'yyyy-mm-dd') ||
 34                                  '08:30:00',
 35                                  'yyyy-mm-dd hh24;mi:ss') or
 36                         vcr.gmt_create >
 37                         to_date(to_char(TRUNC(SYSDATE), 'yyyy-mm-dd') ||
 38                                  '18:00:00',
 39                                  'yyyy-mm-dd hh24;mi:ss'))
 40                     and vcr.CALL_DURATION is not null
 41                   group by vcr.agent_id) b,
 42                 vodka.app_user_ext aue,
 43                 vodka.app_user_role_org auro,
 44                 vodka.app_org ao
 45           where a.agent_id = aue.value
 46             and aue.is_deleted = 'n'
 47             and aue.value is not null
 48             and aue.value <> '0'
 49             and aue.type = 'CC_AGENT'
 50             and aue.domain = 'nirvana'
 51             and aue.login_id = auro.login_id
 52             and ao.id = auro.org_id
 53             and auro.is_deleted = 'n'
 54             and ao.id in
 55                 (select id from vodka.app_org where parent_id = 100013358)
 56             and a.agent_id = b.agent_id(+))
 57   group by id, name;
               vodka.app_user_ext aue,
                     *
ERROR at line 42:
ORA-00600: internal error code, arguments: [kkocxj : pjpCtx], [], [], [], [], [], [], [], [], [], [], []

今天遇到这个错误。查阅文档后，这是11G的一个BUG。有如下解决办法：

该bug可以通过实施one off Patch 7014646修复，也可以尝试通过修改隐式参数_optimizer_push_pred_cost_based禁用基于成本的谓词前置特性(WORKAROUND: disable cost based push predicate)来规避该[KKOCXJ:PJPCTX]内部错误发生，具体的修改方法:

SQL> conn / as sysdba
SQL> alter system set "_optimizer_push_pred_cost_based"=false;
SQL> exit
/* 设置该隐式参数无需重启实例 */

Oracle GCS更推荐通过应用补丁7014646的方法来解决问题，而修改以上隐式参数则不一定百分之百能解决问题。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22034023/viewspace-687313/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22034023/viewspace-687313/