oracle22853,如何巧妙处理enq: TX - index contention问题？

*** 2019-08-21 23:57:14.907===============================================================================HANG ANALYSIS:instances (db_name.oracle_sid): xxxxx===============================================================================Chains most likely to have caused the hang<<<<<<<<<<<<<<<<<<<<<<='buffer busy waits'<='enq: TX - index contention'Chain 1 Signature Hash: 0xbeca5ef7[b] Chain 2 Signature: <='buffer busy waits'<='enq: TX - index contention'Chain 2 Signature Hash: 0xbeca5ef7[c] Chain 3 Signature: <='row cache lock'Chain 3 Signature Hash: 0xccefbfc0===============================================================================Non-intersecting chains:-------------------------------------------------------------------------------Chain 1:-------------------------------------------------------------------------------Oracle session identified by:{instance: 2 (xxxxx)os id: 15343process id: 67session id: 2882session serial #: 39285}is waiting for 'enq: TX - index contention' with wait info:{p1: 'name|mode'=0x54580004p2: 'usn<<16 | slot'=0x470000p3: 'sequence'=0xa32a2d……and is blocked by=> Oracle session identified by:{instance: 2 (xxxxxxx)os id: 105251process id: 79session id: 3400 <<<<<<<<<<<<<<<<<<<<<<='buffer busy waits'<='enq: TX - index contention'Chain 1 Signature Hash: 0xbeca5ef7-------------------------------------------------------------------------------===============================================================================Intersecting chains:-------------------------------------------------------------------------------Chain 2:-------------------------------------------------------------------------------Oracle session identified by:{instance: 2 (xxxxxxx)os id: 70061process id: 69session id: 2969session serial #: 46127}…….and is blocked by 'instance: 2, os id: 83344, session id: 2840',which is a member of 'Chain 1'. <<<<<<<<<<<<<<<<<<<<<<='buffer busy waits'<='enq: TX - index contention'Chain 2 Signature Hash: 0xbeca5ef7--------------------------------------------------------------------------------------------------------------------------------------------------------------Chain 3:-------------------------------------------------------------------------------Oracle session identified by:{instance: 2 (xxxxxx)os id: 102165process id: 75session id: 3227session serial #: 3457}is waiting for 'row cache lock' with wait info:{p1: 'cache id'=0x6p2: 'mode'=0x0p3: 'request'=0x3time in wait: 2.020260 secheur. time in wait: 1 min 59 sectimeout after: 0.979740 secwait id: 360blocking: 0 sessionswait history:* time between current wait and wait #1: 0.000015 sec1. event: 'row cache lock'time waited: 3.001099 secwait id: 359 p1: 'cache id'=0x6p2: 'mode'=0x0p3: 'request'=0x3* time between wait #1 and #2: 0.000015 sec2. event: 'row cache lock'time waited: 3.000983 secwait id: 358 p1: 'cache id'=0x6p2: 'mode'=0x0p3: 'request'=0x3* time between wait #2 and #3: 0.000013 sec3. event: 'row cache lock'time waited: 3.000978 secwait id: 357 p1: 'cache id'=0x6p2: 'mode'=0x0p3: 'request'=0x3}and is blocked by 'instance: 2, os id: 105251, session id: 3400'。which is a member of 'Chain 1'. <<<<<<<<<<<<<<<<<<<<<<='row cache lock'Chain 3 Signature Hash: 0xccefbfc0-------------------------------------------------------------------------------===============================================================================Extra information that will be dumped at higher levels:[level 4] : 1 node dumps -- [LEAF] [LEAF_NW][level 5] : 4 node dumps -- [NO_WAIT] [INVOL_WT] [SINGLE_NODE] [NLEAF] [SINGLE_NODE_NW]State of ALL nodes[2839]/2/2840/17657/0x13d1a33000/83344/NLEAF/[3399][2881]/2/2882/39285/0x13c1a48b38/15343/NLEAF/[2839][2968]/2/2969/46127/0x13b1a69c08/70061/NLEAF/[2839][3226]/2/3227/3457/0x13c1ade618/102165/NLEAF/[3399][3399]/2/3400/22853/0x1391b4cad8/105251/LEAF_NW/*** 2019-08-21 23:57:14.908===============================================================================END OF HANG ANALYSIS===============================================================================*** 2019-08-21 23:58:53.765Suspected Hangs in the SystemRoot Chain Total HangHang Hang Inst Root #hung #hung Hang Hang ResolutionID Type Status Num Sess Sess Sess Conf Span Action----- ---- -------- ---- ----- ----- ----- ------ ------ -------------------1 HANG VALID 2 3400 3 286 HIGH LOCAL Terminate Process<<<<<<<<<<<<<<<<<<< 系统阻塞的可能原因是session id为3400的本地进程引起的inst# SessId Ser# OSPID Event----- ------ ----- --------- -----2 2 19927 111623 enq: TX - index contention2 2840 17657 83344 buffer busy waits2 3400 22853 105251 not in wait*** 2019-08-21 23:58:53.766HM: Short Stack of immediate waiter session ID 2840, OSPID 83344 of hang ID 1Short stack dump:ksedsts()+465