Solve a ORA-03113 Error

A ORA-03113 error solved the original SQL: the execution of a ORA-03113 error, the network is normal, the execution of other SQL is also normal. [SQL] 13:04:26 CRY @ CRY> select operatetime, billtypename, billid, shopcode, shopname, goodscode, goodsn ame, ''initial quantity, sum (irealnumber) irealnumber, DECODE (sum (irealnumber), 0, 0, round (sum (imoney)/sum (irea lnumber), 2) iprice, sum (imoney) imoney, sum (orealnumber) orealnumber, DECODE (sum (orealnumber), 0, 0, roun d (sum (omoney)/sum (orealnumber), 2) oprice, sum (omo Ney) omoney, ''from (select to_char (x. ope ratetime, 'yyyy-MM-DD ') operatetime, x. billtype, 13:04:28 2 fun_getname ('billtypeall', x. billtype) billtypename, 13:04:28 3 x. billid, x. remark, x. originbillid, 13:04:28 fun_getname ('operationtype', x. otherinouttype) otherinouttypename, 13:04:28 5 x. shopcode, 13:04:28 f_getOrganiseName (x. shopcode) shopname, 13:04:28 7 x. storecode, 13:04:28 f_getStore Name (x. storecode) storename, 13:04:28 FUN_GETTOUNIT (x. billtype, x. billid) unitname, 13:04:28 10 x. goodscode, 13:04:28 X. goodsname, 13:04:28 x. response Code, x. brandcode, x. model, 13:04:28 x. irealnumber, 13:04:28 abs (DECODE (x. irealnumber, 0, 0, round (x. imoney/x. irealnumber, 4) iprice, 13:04:28 15 x. imoney, x. orealnumber, 13:04:28 abs (DECODE (x. orealnumber, 0, 0, round (x. omoney/x. orealnumber, 4 ))) Oprice, 13:04:28 x. omoney 13:04:28 18 from (13:04:28 19 select. operatetime, 13:04:28. billtype, 13:04:28. billid, fun_getbillremark (. billid) remark, fun_getbilloriginbillid (. B illid) originbillid, 13:04:28. otherinouttype, 13:04:28. shopcode, 13:04:28. storecode, 13:04:28. goodscode, 13:04:28 c. response Code, c. brandcode, c. model, 13:04:28 c. goodsname, 13:04:28 su M (DECODE (B. ruleid, 1,. realnumber, 2,-. realnumber, 0) irealnumber, 13:04:28 sum (DECODE (B. ruleid, 1, 13:04:28 round (. realnumber *. price, 2), 13:04:28 31 2, 13:04:28 32 round (-1 *. realnumber *. price, 2), 13:04:28 33 0) imoney, 13:04:28 34 sum (DECODE (B. ruleid, 2,. realnumber, 1,-. realnumber, 0) orealnumber, 13:04:28 35 sum (decode (B. ruleid, 2, 13:04:28 round (. realnumber *. price, 2), 13: 04: 28 37 1, 13:04:28 38 round (-1 *. realnumber *. price, 2), 13:04:28 39 0) omoney 13:04:28 40 from TAB_A a, TAB_ B, TAB_C c 13:04:28 41 where. billtype = B. billtype 13:04:28 42 and. goodscode = c. goodscode and (. shopcode = '000000') 13:04:28 43 group by. operatetime, 13:04:28. billtype, 13:04:28. billid, 13:04:28 46 remark, 13:04:28. otherinouttype, 13:04:28. shopcode, 13:04:28 A. storecode, 13:04:28. goodscode, 13:04:28 c. response Code, 13:04:28 c. goodsname, c. brandcode, c. model 13:04:28 53) x 13:04:28 54 where x. billtype in (select billtype from t_billlist where ruleid> 0) and 13:04:28 55 x. operatetime> = to_date ('2017-6-17 ', 'yyyy-MM-DD') 13:04:28 56 and x. operatetime <to_date ('1970-6-18 ', 'yyyy-MM-DD') 13:04:28) a group by operatetime, billtypename, billid, shopco De, shopname, goodscode, goodsname or der by region, billtypename, billid, shopcode, shopname, goodscode, goodsname; select region, billtypename, billid, shopcode, shopname, goodscode, goodsname, ''initial quantity, sum (irealn umber) irealnumber, DECODE (sum (irealnumber), round (sum (imoney)/sum (irealnumber), 2) iprice, sum (imo ney) imoney, sum (orealnumber) orealnumber, DECODE (sum (orealnumber), 0, 0, round (sum (omoney)/su M (orealnumb er), 2) oprice, sum (omoney) omoney, ''Number of balances from (select to_char (x. operatetime, 'yyyy-MM-DD ') ope ratetime, x. billtype, * row 1st ERROR: ORA-03113: file end process ID of communication channel: 20027 session ID: 201 serial number: 149 ERROR: ORA-03114: not connected to ORACLE used time: 00: 00: 02.01 simplified to modify the SQL below after the ORA-600 error: [SQL] 13:07:18 CRY @ CRY> SELECT operatetime 13:07:19 2 FROM (SELECT to_char (x. operatetime, 'yyyy-MM-DD ') operatetime 13:07:19 FROM (SELECT operatetime FROM t_storeout group by operatetime) x 13:07:19 4 WHERE x. operatetime> to_date ('1970-01-01 ', 'yyyy-MM-DD') a 13:07:19 5 group by operatetime; FROM (SELECT operatetime FROM t_storeout group by operatetime) line x * 3rd error: ORA-00600: Internal error code, parameter: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], [], [], [] used time: 00: 00: 01.68 analyze this ORA-00600 error and find it is the influence of the parameter "_ complex_view_merging", Set this parameter to FALSE. if this ORA-00600 error is resolved, the ORA-03113 error is resolved as follows: [SQL] 13:07:23 CRY @ CRY> ALTER SESSION SET "_ complex_view_merging" = false; the SESSION has changed. Used time: 00: 00: 00.01 13:08:43 CRY @ CRY> select operatetime, billtypename, billid, shopcode, shopname, goodscode, goodsn ame, ''initial quantity, sum (irealnumber) irealnumber, DECODE (sum (irealnumber), 0, 0, round (sum (imoney)/sum (irea lnumber), 2) iprice, sum (imoney) imoney, sum (orealnumber) orealnumber, DECODE (sum (orealnumber), 0, 0, roun d (sum (omoney)/sum (orealnumber), 2) oprice, sum (omoney) omoney, ''Number of pairs from (select to_char (x. ope ratetime, 'yyyy-MM-DD ') operatetime, x. billtype, 13:08:55 2 fun_getname ('billtypeall', x. billtype) billtypename, 13:08:55 3 x. billid, x. remark, x. originbillid, 13:08:55 fun_getname ('operationtype', x. otherinouttype) otherinouttypename, 13:08:55 5 x. shopcode, 13:08:55 f_getOrganiseName (x. shopcode) shopname, 13:08:55 7 x. storecode, 13:08:55 f_getStoreName (x. storecode) storename, 13:08:55 FUN_GETTOUNIT (x. billtype, x. billid) unitname, 13:08:55 10 x. goodscode, 13:08:55 X. goodsname, 13:08:55 x. response Code, x. brandcode, x. model, 13:08:55 x. irealnumber, 13:08:55 abs (DECODE (x. irealnumber, 0, 0, round (x. imoney/x. irealnumber, 4) iprice, 13:08:55 15 x. imoney, x. orealnumber, 13:08:55 abs (DECODE (x. orealnumber, 0, 0, round (x. omoney/x. orealnumber, 4) oprice, 13:08:55 17 x. omoney 13:08:55 18 from (13:08:55 19 select. operatetime, 13:08:55. billtype, 13:08:55. billid, fun_getbillremark (. billid) remark, fun_getbilloriginbillid (. B illid) originbillid, 13:08:55. otherinouttype, 13:08:55. shopcode, 13:08:55. storecode, 13:08:55. goodscode, 13:08:55 c. response Code, c. brandcode, c. model, 13:08:55 c. goodsname, 13:08:55 sum (DECODE (B. ruleid, 1,. realnumber, 2,-. realnumber, 0) irealnumber, 13:08:55 sum (DECODE (B. ruleid, 1, 13:08:55 round (. realnumber *. price, 2), 13:08:55 31 2, 13:08:55 32 round (-1 *. realnumber *. price, 2), 13:08:55 33 0) imoney, 13:08:55 34 sum (DECODE (B. ruleid, 2,. realnumber, 1,-. realnumber, 0) orealnumber, 13:08:55 35 sum (decode (B. ruleid, 2, 13:08:55 round (. realnumber *. price, 2), 13:08:55 37 1, 13:08:55 38 round (-1 *. realnumber *. price, 2), 13:08:55 39 0) omoney 13:08:55 40 from t_storeout a, t_billlist B, t_goods c 13:08:55 41 where. billtype = B. billtype 13:08:55 42 and. goodscode = c. goodscode and (. shopcode = '000000') 13:08:55 43 group by. operatetime, 13:08:55. billtype, 13:08:55. billid, 13:08:55 46 remark, 13:08:55. otherinouttype, 13:08:55. shopcode, 13:08:55. storecode, 13:08:55. goodscode, 13:08:55 c. response Code, 13:08:55 c. goodsname, c. brandcode, c. model 13:08:55 53) x 13:08:55 54 where x. billtype in (select billtype from t_billlist where ruleid> 0) and 13:08:55 55 x. operatetime> = to_date ('2017-6-17 ', 'yyyy-MM-DD') 13:08:55 56 and x. operatetime <to_date ('1970-6-18 ', 'yyyy-MM-DD') 13:08:55) a group by operatetime, billtypename, billid, shopcode, shopname, goodscode, goodsname or der by operatetime, billtypename, billid, shopcode, shopname, goodscode, goodsname; used time of unselected row: 00: 00: 00.04