Locks in Oracle
920232Mar 21 2012 — edited Mar 21 2012hi 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!