My Oracle Support Banner

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

Last updated on MARCH 11, 2020

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



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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.