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!

V$Lock and V$locked_object

Salman QureshiApr 22 2009 — edited Apr 28 2009

Hi,
If i query v$lock, i am returned a lot of rows with TYPE=TX and with LMOD=6 but mean while if i query v$locked_object, i don't see any objects are locked, For the same SID i find in v$lock, i also fined undo segments allocated. why i dont see any locked objects in v$locked_object?
Thanks

Salman

Locked Post

New comments cannot be posted to this locked post.

Locked on May 26 2009

Added on Apr 22 2009

#general-database-discussions

2 comments

1,539 views