locks

[jayasudha]

Hi

We have bulk DML process that uses ArcSDE 11.1.

I observed dba_lock view in oracle 11gR2 regularly for the following.

select * from dba_lock where session_id=226;

sid      lock_type                                   mode_held                                                                last_convert

226	AE	Share	None	100	0	4355	Not Blocking
226	PL/SQL User Lock	Exclusive	None	1073742268	0	4354	Not Blocking
226	TO	Row-X (SX)	None	68064	1	4218	Not Blocking

Various locks are applied and released regularly and after some time, the locks do not change except the LAST_CONVERT value keep on increasing. Then the process hangs.

The log switch activity is at every 15 min.

Please inform your suggestion

[jayasudha]

I observed one more thing.

SELECT * FROM sde.table_locks;

214	267	S	05-02-16
218	246	S	05-02-16

The application is not able to release above mentioned locks