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

Last updated on OCTOBER 20, 2016

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms