My Oracle Support Banner

Parallel Execution ORA-29771: P00I BLOCKS CKPT > 70 SEC (Doc ID 1995692.1)

Last updated on APRIL 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

Parallel Execution ORA-29771: P00I BLOCKS CKPT > 70 SEC


Can see the below informaiton in alert log:

CKPT (ospid: 32608) waits for event 'latch: parallel query alloc buffer' for
74 secs.
CKPT (ospid: 32608) waits for latch 'parallel query alloc buffer' for 74
secs.
Errors in file
/ade/b/215434914/oracle/diag/rdbms/custdb/custdbi1/trace/custdbi1_lmhb_32543.t
rc (incident=112153):
ORA-29771: process P00I (OSID 1218) blocks CKPT (OSID 32608) for more than 70
seconds
Incident details in:
/ade/b/215434914/oracle/diag/rdbms/custdb/custdbi1/incident/incdir_112153/cust
dbi1_lmhb_32543_i112153.trc
Sat Oct 19 17:12:05 2013
P00I (ospid: 1218) is blocking CKPT (ospid: 32608) in a wait
LMHB (ospid: 32543) kills P00I (ospid: 1218).
Please check LMHB trace file for more detail.
Sat Oct 19 17:13:04 2013
PMON failed to acquire latch, see PMON dump
Sat Oct 19 17:13:05 2013
CKPT (ospid: 32608) waits for event 'latch: parallel query alloc buffer' for
155 secs.
CKPT (ospid: 32608) waits for latch 'parallel query alloc buffer' for 155
secs.
Sat Oct 19 17:13:05 2013
CKPT (ospid: 32608) is hung in an acceptable location (inwait|latch-get
0x5.ffff).
CKPT (ospid: 32608) waits for event 'latch: parallel query alloc buffer' for
165


ERROR STACK:

secs@ ksedsts()+205<-ksdxfstk()+34<-ksdxcb()+911<-sspuser()+224<-__sighandler()<-sem
@ op()+7<-skgpwwait()+155<-kslges()+1266<-kslgetl()+716<-kxfpbfre()+255<-kxfpqrs
@ od()+618<-kssdel()+362<-kxfpdelqrefs()+124<-kxfpqsod_qc_sod()+860<-kxfpqsod()+
@ 393<-kxfrcls()+240<-qerpx_stop()+375<-qerpxFetch()+1611<-rwsfcd()+124<-qersoPr
@ ocessULS()+304<-qersoFetchSimple()+1196<-qersoFetch()+210<-opifch2()+3146<-opi
@ fch()+62<-opiodr()+1133<-kpoodr()+1198<-upirtrc()+2434<-kpurcsc()+102<-kpufch0
@ ()+1826<-kpufch()+1397<-OCIStmtFetch2()+11<-kwslbInterLB()+3322<-kwslbbgCoord(
@ )+2543<-kwsbgMsProc()+303<-kwsbgcbkms()+15<-ksvrdp()+2044<-opirip()+664<-opidr
@ v()+610<-sou2o()+129<-opimai_real()+262<-ssthrdmain()+397<-main()+222<-__libc_
@ start_main()+244 .
Sat Oct 19 17:13:15 2013
CKPT (ospid: 32608) waits for latch 'parallel query alloc buffer' for 165
secs.



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


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.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.