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||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