locks

1506
1
05-01-2016 11:14 PM
jayasudha
New Contributor III


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

226AEShareNone10004355Not Blocking
226PL/SQL User LockExclusiveNone107374226804354Not Blocking
226TORow-X (SX)None6806414218Not 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

0 Kudos
1 Reply
jayasudha
New Contributor III

I observed one more thing.

SELECT * FROM sde.table_locks;

214267S05-02-16
218246S05-02-16

The application is not able to release above mentioned locks

0 Kudos