Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to handle locked objects problem?

ronald_2017Apr 21 2020 — edited Apr 21 2020

Hi All,

Oracle 11gR2

There are 234 rows in V$LOCKED_OBJECT table. All of them LOCKED_MODE = 3.

SELECT v.XIDUSN, v.XIDSLOT, v.XIDSQN, v.OBJECT_ID, v.SESSION_ID, v.LOCKED_MODE FROM V$LOCKED_OBJECT v;
692    31    389588    83035    9    3
485    11    393461    83035    10    3
888    22    359117    83035    23    3
713    11    399098    83038    29    3
713    11    399098    83035    29    3
680    12    386661    83035    40    3
722    7    385569    83038    41    3
722    7    385569    83035    41    3
.......

SELECT count(*) FROM V$LOCKED_OBJECT v;
234

Hoever, there no rows in DBA_WAITERS

SELECT * FROM DBA_WAITERS;
>> no rows

How to solve this problem?

Thanks

This post has been answered by Joerg.Sobottka on Apr 21 2020

Jump to Answer

Added on Apr 21 2020

#general-database-discussions

8 comments

3,453 views