Table Lock on Select for Update?
From: <BJSIEBEN_at_bcsc02.gov.bc.ca>
Date: 1995/05/09
Message-ID: <17399783FS86.BJSIEBEN_at_bcsc02.gov.bc.ca>#1/1
Date: 1995/05/09
Message-ID: <17399783FS86.BJSIEBEN_at_bcsc02.gov.bc.ca>#1/1
If anyone can confirm what I've heard about Select for Update. What I
heard was: when the select for update is issued, Oracle locks the row(s)
in the select, but when the actual update occuer (ie. update....) Oracle
will lock the entire table while the actual update is happening.
Has anyone else heard this? I find it hard to believe the entire table
is locked for the brief time the actual update occurs. We are using
Oracle7 on AIX.
.....Barry Sieben