Hi ALL,
we are trying to delete a record from a Table which has million rows. but the delete operation taking lot of time and waiting for the enq: TM - contention.
DELETE IS_NOTE
WHERE
ID IN (SELECT ID_OLD FROM IS_NOTE_ADT WHERE ID_NEW = :B1 AND
ID_NEW != ID_OLD)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 0 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1 0.00 0.00 0 0 0 0
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 28 (recursive depth: 1)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
enq: TM - contention 119 3.00 354.26