Parallel Query Fails with ORA-600 [15764] [ID 839536.1]
来源:互联网 发布:三维矩阵旋转 编辑:程序博客网 时间:2024/05/14 05:58
In this Document
Symptoms
Cause
Solution
References
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.3 to 11.2.0.1 - Release: 10.2 to 11.2Information in this document applies to any platform.
Symptoms
A select statement running in parallel failed with ORA-600 [15764].
The tracefile showed the following call stack:
----- Call Stack Trace -----
kxfprigdb <- kxfpqrgdb <- kxfxgs <- kxfxcw <- qerpxFetch <- opifch2 <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real <- main <- start
kxfprigdb <- kxfpqrgdb <- kxfxgs <- kxfxcw <- qerpxFetch <- opifch2 <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real <- main <- start
The tracefile also showed the process state was busy holding a child latch:
===================================================
PROCESS STATE
-------------
Process global information:
process: 7000004748eaa00, call: 700000443d33870, xact: 0, curses: 700000474e203c8, usrses: 700000474e203c8
----------------------------------------
SO: 7000004748eaa00, type: 2, owner: 0, flag: INIT/-/-/0x00
(process) Oracle pid=157, calls cur/top: 700000443d33870/700000443d33870, flag: (0) -
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 249
last post received-location: kxfprienq: QC
last process to post me: 700000474914f40 186 0
last post sent: 0 0 250
last post sent-location: kxfprienq: slave
last process posted by me: 700000474914f40 186 0
(latch info) wait_event=0 bits=10
holding (efd=7) 700000472e4a838 Child process queue reference level=4 child#=99
Location from where latch is held: kxfprigdb: KSLBEGIN: addr qref <---
Context saved from call: 504403177372952360
state=busy, wlstate=free <----
Process Group: DEFAULT, pseudo proc: 700000474a384f0
O/S info: user: oracle, term: UNKNOWN, ospid: 2351144
OSD pid info: Unix process pid: 2351144, image: oraclePPSOLTP1@psoldbap003
Cause
The error is caused by unpublished Bug 9825798: "DBMV2:SQL EXEC PART:ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [15764]," which was closed as unpublished Bug 9792010: "DBMV2: STARETL_EXADATA: INSTANCE TERMINATES AFTER MULTIPLE PQ ERRORS."
This error has been seen as early as 10.2.0.3 and is fixed by the 11.2.0.2 patch set. The error is not RAC specific.
Solution
The following solutions are available:- Upgrade to 12.1 (Future Release).
- Apply the 11.2.0.2 Server Patch Set.
- Apply the 11.2.0.1 Bundle Patch 8 (Exadata Database only).
- Apply one-off Patch 9792010 if available for your RDBMS version and OS platform.
- Workaround:
Increase parallel message size to avoid join message fragmentation.
The join message will be sent in one message buffer making the join atomic
from the QC point of view.
Note: Although the patch name contains the word "Exadata," this is a generic RDBMS parallel execution bug and is not exclusive to Exadata databases.
References
NOTE:9792010.8 - Bug 9792010 - Dumps / ORA-600 in PQ slaves due to race condition相关内容
产品
- Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
PARALLEL EXECUTION; PARALLEL QUERY; FAILED ACTIVITY错误
ORA-600[15764]; ORA-600[[15764]; ERROR 0
- Parallel Query Fails with ORA-600 [15764] [ID 839536.1]
- Impdp Fails with ORA-39126 ORA-911 During Create Function (文档 ID 1254246.1)
- Create Database With DBCA on 11.2.0.3, Fails with ORA-29516 (Doc ID 1450281.1)
- DataPump Import Of Object Types Fails With Errors ORA-39083 ORA-2304 Or ORA-39117 ORA-39779 (Doc ID
- ASM disk group mount fails with ORA-15036: disk is truncated [ID 1077175.1]
- Adding a standby database to a dataguard configuration fails with ORA-1017 (Doc ID 1072022.1)
- Alter database open fails with ORA-00600 kcratr_nab_less_than_odr (文档 ID 1296264.1)
- DataPump Import (IMPDP) Fails With Error ORA-39083 Object Type INDEX_STATISTICS (文档 ID 1454880.1)
- Parallel Query 导致的ORA-04031
- Gather Schema Statistics fails with Ora-20001
- Login with RMAN immediately fails with ORA-04031, ORA-06508
- ORA-10388: parallel query server…
- Drop Materialized View with Fails with ORA-4020 and getting ORA-955 while Recreating MVIEW
- ORA-600 [13004] Raised With CREATE INDEX (文档 ID 1667585.1)
- Oracle 11g listener fails with ORA-12514 and ORA-12505 errors
- Bug 11775332 - cluvfy fails with PRVF-5636 with DNS response timeout error [ID 11775332.8]
- ORA-15077 PROC-26 CRSD Fails During CRS Startup on 11gR2 [ID 1152583.1]
- ORA-15077 PROC-26 CRSD Fails During CRS Startup on 11gR2 [ID 1152583.1]
- C/C++ 语言中结构体的内存分配
- CIO如何推广ERP系统
- iOS icon 尺寸总结
- 【随笔】技术学习,需持之以恒
- JAVA一些好用的API方法
- Parallel Query Fails with ORA-600 [15764] [ID 839536.1]
- 结构体大小
- Linux 2.6.19.x 内核编译配置选项简介
- flex加密与解密1
- Solaris vmstat
- ipad开发从图片库中加载图片
- Select函数实现原理分析
- 对标准函数库的理解
- package,source folder,folder 的区别和联系