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

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

--//http://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], [], [], [], [], [], [], [], [], [], []

--//如果取消並行,錯誤消失!!