Q & A

[alert 파일에 오렌지사용으로 인한 ora-00600에러 발생

Date2003.05.09 / Hit : 15032
오늘 오전에 특별히 orange를 쓴것도 아닌데. 600에러가 발생했습니다. 해당 trace를 보니 다음과 같이 에러가 났습니다. 답변 기다리겠습니다. *** SESSION ID:(305.37360) 2003-05-09 09:44:08.084 *** 2003-05-09 09:44:08.084 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [12443], [], [], [], [], [], [], [] Current SQL statement for this session: EXPLAIN PLAN SET STATEMENT_ID='Orange305' INTO orange.orange_plan_table FOR select /*+ ORDERED USE_NL(B A) INDEX(A) +*/ A.spec_seq_no ,A.dmd_type ,A.dmd_type_cd ,A .ykiho ,A.form_cd ,A.insurer_cd ,A.pat_nm ,A.pat_jumin_no ,A.recu_fr_dt ,A.main_sick ,A.su b_sick ,A.opr_yn ,DECODE(:b0,'1',A.dsbjt_cd,:b1) dsbjt_cd ,A.recn ,A.vscn ,A.dmd_tramt ,A. dmd_sbrdn_amt ,A.dmd_jbrdn_amt ,A.edec_tramt ,A.edec_sbrdn_amt ,A.edec_jbrdn_amt ,A.edec_a dd_rt ,A.edec_drg_no ,A.diag_rslt_type from (select X.recv_no ,X.recv_yyyy ,X.brch_cd ,X. bill_seq_no ,X.spec_seq_no from tbjhc20_dl_hiradb01 X ,tbjhc30_dl_hiradb01 Y where (((((( (((((((X.recv_no=:b2 and X.recv_yyyy=:b3) and X.brch_cd=:b4) and X.bill_seq_no=:b5) and X. form_cd in ('02','06','07')) and X.recu_fr_dt like '2002%') and X.edec_tramt>0) and (X.dsb jt_cd='10' or :b1='10')) and Y.recv_no(+)=X.recv_no) and Y.recv_yyyy(+)=X.recv_yyyy) and Y .brch_cd(+)=X.brch_cd) and Y.bill_seq_no(+)=X.bill_seq_no) and Y.spec_seq_no(+)=X.spec_seq _no) and (((SUBSTR(X.main_sick,1,1)='O' or SUBSTR(X.main_sick,1,3) in ('P01','P02','P03',' P05','P59','R03','Z34','Z35')) or (SUBSTR(X.sub_sick,1,1)='O' or SUBSTR(X.sub_sick,1,3)
  • 대표전화
    1660-1675

  • 기술 문의
    02-6931-1734

  • 오렌지 문의
    070-8666-8175

  • 라이선스 문의
    02-6931-1728