暂无图片
【Oracle】child cursor过多高并发环境下产生cursor:mutex x和cursor:mutex s等待
最近更新:2022-03-11 14:21:05

故障描述:

客户数据库Oracle 12.1.0.2 RAC某个节点16点30分钟左右SQL_ID gr5jm3av0n5sx出现了大量的cursor:mutex x、cursor:mutex s等待,CPU使用率接近100%

系统环境:Oracle 12.1C RAC HP-UNIX

1.数据库出现大量的cursor:mutex x和cursor :mutex s等待

交易库01.png

2.查看相关SQL_ID gr5jm3av0n5sx的相关信息

SQL_ID  gr5jm3av0n5sx, child number 107
-------------------------------------
UPDATE T_BPM_PROCESSINSTANCE T_BPM_PROCESSINSTANCE
   SET PROCESSSTATE       = :p1,
       PREVIOUSSTATE      = :p2,
       CLUSTERNODEID      = :p3,
       CURACTIVITYDEFID   = :p4,
       CURACTIVITYID      = :p5,
       PREVACTIVITYINSTID = :p6,
       CURACTIVITYSTATE   = :p7,
       ELEMENTLOOPCOUNTER = :p8,
       STARTTIME          = :p9,
       LASTUPDATETIME     = :p10,
       ACTIVITYCOUNT      = :p11,
       CURSEQUENCENUM     = :p12,
       TIMERSTATE         = :p13,
       PREDACTIVITIES     = :p14,
       SUSPENDACTIVITIES  = :p15,
       SKIPPEDACTIVITIES  = :p16,
       JOINEDELEMENTIDS   = :p17,
       JOINEDTRANSITIONS  = :p18,
       METADATA           = :p19,
       ISEXECUTING        = :p20,
       ASYNCELEMENTDEFID  = :p21,
       ASYNCRETRYCOUNT    = :p22,
       ASYNCELEMENTINSTID = :p23,
       CURELMNTSTARTTIME  = :p24,
       BUSINESSSTATUS     = :p25,
       PI_EXTN_05         = :p26,
       PI_EXTN_08         = :p27,
       PI_EXTN_12         = :p28,
       PI_EXTN_13         = :p29,
       PI_EXTN_21         = :p30,
       PI_EXTN_26         = :p31,
       PI_EXTN_27         = :p32
 WHERE PROCESSINSTANCEID = :p33
   AND L2_PARTITION_KEY = :p34

Plan hash value: 2404250912
--------------------------------------------------------------------------------------------------------------------------------
| Id  | Operation                           | Name                     | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
......