[20230108]ORA-00600 and Session Disconnected 2.txt

来源:这里教程网 时间:2026-03-03 18:20:41 作者:

[20230108]ORA-00600 and Session Disconnected 2.txt --//ksun-oracle.blogspot.com/2022/07/plsql-ora-00600-by-jdbc-call-exception.html --//测试:ORA-00600 and Session Disconnected 1.环境: SCOTT@test01p> @ ver1 PORT_STRING                    VERSION        BANNER                                                                               CON_ID ------------------------------ -------------- -------------------------------------------------------------------------------- ---------- IBMPC/WIN_NT64-9.1.0           12.2.0.1.0     Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production              0 2.测试脚本: --//drop type t_char100_varray50_test force; create or replace noneditionable type t_char100_varray50_test as varray(50) of varchar2(100) / --//drop table test_tab_disconnet_no cascade constraints; create table test_tab_disconnet_no as select level id, t_char100_varray50_test('a', 'b', 'c') vary   from dual connect by level <= 1e4; alter table test_tab_disconnet_no add constraint test_tab_disconnet_no#p primary key (id); create or replace procedure test_ora_600_disconnet_no as begin   for c in (     select /*+ parallel(4) index(t test_tab_disconnet_no#p) */ t.id, count(*)       from test_tab_disconnet_no t, table(t.vary) v     where rownum <= 3000     group by t.id)   loop     null;   end loop; end; / 3.测试: SCOTT@test01p> exec test_ora_600_disconnet_no; BEGIN test_ora_600_disconnet_no; END; * ERROR at line 1: ORA-00600: internal error code, arguments: [qernsRowP], [1], [], [], [], [], [], [], [], [], [], [] --//如果取消并行,错误消失!!

相关推荐