Parallel Execution ORA-29771: P00I BLOCKS CKPT > 70 SEC
(Doc ID 1995692.1)
Last updated on FEBRUARY 22, 2024
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 |