Skip to Main Content

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!

Locks in Oracle

920232Mar 21 2012 — edited Mar 21 2012
hi all,

We have a job running in background that is trying to update a table in the database. At the same time we have a user with only select privilege on the table performing a select on that table. The job hung and when we checked the V$locked_object view, we found that the table had a lock mode '3' for both the sessions trying to access the table. Can someone tell me what lock_mode 3 means and how this lock is possible?

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 18 2012
Added on Mar 21 2012
3 comments
6,116 views