启用 Result Cache 后发生错误 'ORA-32701: Possible hangs up to hang ID= detected' (Doc ID 2504952.1)

Last updated on AUGUST 12, 2020

适用于:

症状

• 启用 Result Cache 后，发生 ORA-32701:
  DIA0 terminating blocker (ospid: 329 sid: 148 ser#: 2320) of hang with ID = 34
  requested by master DIA0 process on instance 1
  Hang Resolution Reason: Automatic hang resolution was performed to free a
  critical database process.
  by terminating session sid:148 with serial # 2320 (ospid:329)
  DIA0 successfully terminated session sid:148 with serial # 2320 (ospid:329) with status 31.
  
  ORA-32701: Possible hangs up to hang ID=34 detected
   
• 如 stack 显示，查询的时间花费在 从 SGA 的 Reault Cache 中释放空间上:
  
  
  ktcnqSGAFreeQueryInternal()+1576<-ktcnqSGAFreeQuery()+612<-ktcnqSGADeleteQueries()+200<-ktcnqRefreshObjectCache() >>>

  loadavg : 1.55 1.18 0.97
  swap info: free_mem = 30377.16M rsv = 12804.41M
  alloc = 70476.25M avail = 168251.64M swap_free = 110579.80M
  
  Short stack dump:
  ksedsts()+572<-ksdxfstk()+44<-ksdxcb()+1004<-sspuser()+240<-ssprtmin()+188<-__sighndlr()+12<-call_user_handler()+992<-sigacthandler()+104<-ktcnqSGAFreeQueryInternal()+1576<-ktcnqSGAFreeQuery()+612<-ktcnqSGADeleteQueries()+200<-ktcnqRefreshObjectCache()+2740<-ktcnqQctxAcquirePredicateLocks()+316<-ktcnPublishRegistration()+1272<-ktcnRegisterQuery1()+476<-ktcnRegisterQuery()+1196<-ktcncRegisterQuery()+1176<-kpoqqreg()+872<-selexe0()+1472<-opiexe()+5496<-kpoal8()+2220<-opiodr()+1100<-ttcpip()+972<-opitsk()+1832<-opiino()+920<

更改

启用 Result Cache

原因

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