Hi Gurus,
I am facing an issue with one of the applications which has very high enqueue waits showing up in the AWR report. When I checked it through a scirpt, I can see that the holding session is changing very quickly which means that the lock itself is held for a very short time but there are too many sessions which are getting and releasing the locks. Killing the session wont be an option. What are my options here.
DB Details:
Version 10.2.0.4
OS Windows Server 2003 R2
Code:Output from the script: SESS ID1 ID2 LMODE REQUEST TY INST_ID SQL_TEXT -------------------- ---------- ---------- ---------- ---------- -- ---------- ---------------------------------------------------------------------------------------------------- Holder: 120 10 37750683 6 0 HW 1 UPDATE T_CKC_RUNTIME SET ckc_blob = :BP_00002_v:BP_00002_i, first_sample_date = : Waiter: 117 10 37750683 0 6 HW 1 UPDATE T_CKC_RUNTIME SET ckc_blob = :BP_00002_v:BP_00002_i, first_sample_date = :




Reply With Quote