oracle 11.2.0.4.181016
linux
rac
insert all into 语句本来是为了提升速度,结果遇到ora-600错误
-
Dump file /u01/app/oracle/diag/rdbms/orcl/orcl2/incident/incdir_48490/orcl2_ora_23220_i48490.trc
-
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
-
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
-
Data Mining and Real Application Testing options
-
ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/db_1
-
System name: Linux
-
Node name: host02
-
Release: 3.10.0-514.el7.x86_64
-
Version: #1 SMP Wed Oct 19 11:24:13 EDT 2016
-
Machine: x86_64
-
VM name: VMWare Version: 6
-
Instance name: orcl2
-
Redo thread mounted by this instance: 2
-
Oracle process number: 59
-
Unix process pid: 23220, image: oracle@host02
-
-
-
*** 2021-09-15 14:02:32.168
-
*** SESSION ID:(1566.19235) 2021-09-15 14:02:32.168
-
*** CLIENT ID:() 2021-09-15 14:02:32.168
-
*** SERVICE NAME:(orcl) 2021-09-15 14:02:32.168
-
*** MODULE NAME:(JDBC Thin Client) 2021-09-15 14:02:32.168
-
*** ACTION NAME:() 2021-09-15 14:02:32.168
-
-
Dump continued from file: /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_23220.trc
-
ORA-00600: 内部错误代码, 参数: [mal0-size-too-large], [vecConvRwm_qermtm:qermtPostAllocate], [], [], [], [], [], [], [], [], [], []
-
-
========= Dump for incident 48490 (ORA 600 [mal0-size-too-large]) ========
-
-
*** 2021-09-15 14:02:32.226
-
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
-
----- Current SQL Statement for this session (sql_id=5bpkbwa848mww) -----
-
insert all
-
into tbl_temp1
-
(id,name,argid,ovrd_ind,aind,sind)
-
VALUES
-
(
-
:1,
-
:2,
-
:3,
-
:4,
-
:5,
-
:6
-
)
-
-
into tbl_temp1
-
(id,name,argid,ovrd_ind,aind,sind)
-
VALUES
-
(
-
:7,
-
:8,
-
:9,
-
:10,
-
:11,
-
:12
-
)
-
一万条插入
经搜索,判断可能与bug有关
这个案例的call stack:
导致这个ora-600的还有其他的原因:
参考:
Doc ID 1928333.1
Doc ID 553051.1
阅读(1195) | 评论(0) | 转发(0) |