Row_Locking parameter

From: Byron Pearce <bpearc1_at_abacus.tis.tandy.com>
Date: 2 Sep 1994 20:22:23 GMT
Message-ID: <3481hv$kfo_at_abacus.tis.tandy.com>

I need some additional information on the row_locking parameter mentioned in the Oracle V7 RDBMS DBA Guide. Primarily: what's the difference? Does a value of ALWAYS mean that you only get a row-level lock whenever an UPDATE is performed, while INTENT means that you get a row-level lock with a SELECT..FOR UPDATE as well as an actual UPDATE? Does an always mean that you cannot lock using SELECT..FOR UPDATE?

The book is rather cryptic here. Can anyone shed some light?

Byron Pearce

---

Byron Pearce                        |  The thoughts and views herein do not
Tandy Information Services          |  necessarily reflect that of Tandy
bpearc1_at_abacus.tis.tandy.com        |  Corporation.
------------------------------------------------------------------------------

"It's hard to be a ninja when you wear a beeper."

---

Received on Fri Sep 02 1994 - 22:22:23 CEST