problème de enq: TX - row lock contention
Bonjour,
J'ai un problème de lock.
D'après le rapport AWR : deux lignes sont lockées sur une table particulière.
Si je connais la table en question comment puis je élargir mes recherches ?
Ci joint l'extrait du rapport AWR.
Merci d'avance,
Frédéric.
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
enq: TX - row lock contention 246 735 2989 98.5 Applicatio
db file sequential read 395 6 16 0.8 User I/O
control file parallel write 310 4 14 0.6 System I/O
CPU time 2 0.3
control file sequential read 1,042 1 1 0.1 System I/O
-------------------------------------------------------------
Segments by Row Lock Waits DB/Inst: AIRS/airs Snaps: 10092-10093
-> % of Capture shows % of row lock waits for each top segment compared
-> with total row lock waits for all segments captured by the Snapshot
Row
Tablespace Subobject Obj. Lock % of
Owner Name Object Name Name Type Waits Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
AIRS_GESTD TS_AIRS_DA HIT_ALPHA_NUM TABLE 2 100.00
------------------------------------------------------------- |
