My Oracle Support Banner

在 LOB 对象上执行 DML 时,数据库hang 在'gc index operation' (Doc ID 2504905.1)

Last updated on JULY 31, 2019

适用于:

Oracle Database - Enterprise Edition - 版本 12.2.0.1 和更高版本
本文档所含信息适用于所有平台

症状

当在 LOB 对象上执行DML时,数据库hang住。

}
and is blocked by
=> Oracle session identified by:
{
instance: 2 (xxxxxxxx.xxxxxxx2)
os id: 28836042
process id: 106, oracle@xxxxxx06
session id: 4545
session serial #: 50133
}
which is waiting for 'gc index operation' with wait info:
{
p1: 'usn#'=0x6
p2: 'slot#'=0x1b
p3: 'seq#'=0x2484
time in wait: 0.012699 sec
timeout after: 0.087301 sec
wait id: 233929
blocking: 16 sessions
current sql: MERGE INTO FBNK_STMT_PRINTED USING DUAL ON (RECID = :RECID) WHEN MATCHED THEN UPDATE SET XMLRECORD=:XMLRECORD WHEN NOT MATCHED THEN INSERT (XMLRECORD ,RECID) VALUES(:XMLRECORD ,:RECID)
short stack: ksedsts()+432<-ksdxfstk()+68<-ksdxcb()+892<-sspuser()+220<-__sighandler()<-thread_wait()+556<-sskgpwwait()+56<-skgpwwait()+268<-IPRA.$ksliwat()+1936<-kslwaitctx()+200<-kclsplitwait()+1228<-kcbgcur()+18212<-ktbgcur()+128<-kdifind()+600<-kdimod0()+1248<-IPRA.$kdlfkd()+2580<-kdlxgsd()+720<-IPRA.$ktsplbfmb_reclaim()+1916<-ktsplbfmb()+2808<-ktsplbrecl()+1020<-ktspgsp_main()+3492<-IPRA.$kdlgsp_init()+1400<-kdl_write1()+6528<-kdl_copy()+1676<-kdlf_copy()+656<-IPRA.$kokl_pdbaware_kdlf_copy()+396<-IPRA.$kokliclo()+644<-kok
wait history:
* time between current wait and wait #1: 0.001052 sec
1. event: 'gc current split'
time waited: 0.001972 sec
wait id: 233928 p1: ''=0xc
p2: ''=0x214b
p3: ''=0x1000001
* time between wait #1 and #2: 0.000553 sec
2. event: 'gc index operation'
time waited: 0.099095 sec
wait id: 233927 p1: 'usn#'=0x6
p2: 'slot#'=0x1b
p3: 'seq#'=0x2484
* time between wait #2 and #3: 0.000194 sec
3. event: 'gc current split'
time waited: 0.003181 sec
wait id: 233926 p1: ''=0xc
p2: ''=0x214b
p3: ''=0x1000001
}

Chain 1 Signature: 'gc index operation'<='enq: HW - contention'
Chain 1 Signature Hash: 0x99872a5a
-------------------------------------------------------------------------------

 

原因

To view full details, 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 a vibrant support community of peers and Oracle experts.