Hi Pablo,
Thanks for your response. I apologize for pasting the wrong output. I am aware of the bug and we are going to put a fix for it. But there is also very short TX type locks which occur. Wanted to know how to resolve those.

Code:
Holding SID: 115

Lock Mode: 6

Request Mode: 0

Request Type: TX

Waiting (sec): 0

SQL Text: UPDATE T_CKC_RUNTIME                  SET ckc_blob =  :BP_00002_v:BP_0

0002_i, first_sample_date =  :BP_00003_v:BP_00003_i, last_sample_date =  :BP_000

 

 

Kill command (sqlplus): alter system kill session '115,20';

 

Waiting SID: 125

Lock Mode: 0

Request Mode: 6

Request Type: TX

Waiting (sec): 32

SQL Text: SELECT /*+ NOPARALLEL (t_ckc_runtime)*/ r.ch_id, r.ckc_id, r.folder_id

, r.fxs_available, r.min_sample_size, r.max_sample_size, r.ckc_blob, t.reset_dat