hi,

One of my processes,(Daily updation) is taking unusally long time. I checked up in the v$objects_locked. I got the object id on which there is a lock.

I have got the object name(all_objects), It's the same table on which updation happens.

Question is.: how do i know whether this lock is a lock put by any other processes or it's the lock obtained by the table itself for the purpose of DML.

Badrinath