Hi all, faced with enq: TX - row lock contention
but no booking session info in gv$session or ash =\
select count
(*),event,BLOCKING_SESSION,BLOCKING_SESSION_SERIAL#,blocking_inst_id from
gv$active_session_history where event like '%TX%' and sample_time> sysdate-1/24
group by bLOCKING_SESSION,BLOCKING_SESSION_SERIAL#,blocking_inst_id,event;
| | BLOCKING |
|
COUNT(*) | Event | SID |
BLOCKING_SESSION_SERIAL# | BLOCKING_INST_ID
---------- | ---------------------------------------- | ---------- |
------------------------ | ----------------
3520 | enq: TX - row lock contention | |
|
1 | enq: TX - index contention | 10908 |
33849 | 1
5 | enq: TX - row lock contention | 2259 |
3041 | 1
what can it be ?
ps: Bug 5010879 - V$SESSION slow and does not show any BLOCKING_SESSION column
data (Doc ID 5010879.8)
not my case, we use 12.1.0.2.16.01.2016