This is the tkprof out put by seeing any body can tell what are the possible cause for locking
This is the tkprof out put by seeing any body can tell what are the possible cause for locking
TKPROF: Release 10.2.0.3.0 - Production on Sun Jun 14 23:12:53 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.Trace file: /oracle/admin/DMDIQA1/udump/dmdiqa1_ora_27595_DM_ASSURAR_PKG_2.trcSort options: default********************************************************************************count = number of times OCI procedure was executedcpu = cpu time in seconds executing elapsed = elapsed time in seconds executingdisk = number of physical reads of buffers from diskquery = number of buffers gotten for consistent readcurrent = number of buffers gotten in current mode (usually for update)rows = number of rows processed by the fetch or execute call********************************************************************************declare cursor NlsParamsCursor is SELECT * FROM nls_session_parameters;begin SELECT Nvl(Lengthb(Chr(65536)), Nvl(Lengthb(Chr(256)), 1)) INTO :CharLength FROM dual; for NlsRecord in