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
