ORA-29771 [USER] [LGWR] (Doc ID 2831441.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Receiving ORA-29771 [USER] [186986] [LGWR] [275652] 
 
ORA-29771: process USER (OSID 186986) blocks LGWR (OSID 275652) for more than 70 seconds <<<=====

...

(LGWR), OS id=275652

Short stack dump:
ksedsts()+346<-ksdxfstk()+71<-ksdxcb()+912<-sspuser()+217<-__sighandler()<-__p
oll()+16<-ipcgxp_selectex()+409<-ipclw_wait()+1045<-ksxpwait_ipclw()+3844<-ksx
pwait_int()+22103<-ksxpwait()+845<-ksliwat()+11013<-kslwaitctx()+197<-kglLockW
ait()+856<-kgllkal()+1634<-kglLock()+1342<-kglLockInstanceInt()+162<-kglLockIn
stance()+802<-kksExclusiveParseLockCbk()+293<-kksExclusiveParseLock()+108<-krd
rsb_mdflush_local()+473<-krdrsb_lgwr_chintr()+1090<-ksbcti()+247<-ksbabs()+551
<-ksbrdp()+1079<-opirip()+609<-opidrv()+602<-sou2o()+145<-opimai_real()+202<-s
sthrdmain()+417<-main()+262<-__libc_start_main()+245

Cause

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