Re: locking in Oracle

>> I want my transactions in Oracle to have repeatable reads
>> (degree 3 consistency) but the default is only degree 2.
>> I know that I can get degree 3 if I explicitly set share locks
>> on table or exclusive locks on the rows which must return
>> repeatable reads (as stated on page 10-7 in the concept manual)
>> but is there anyway one can set some option so that Oracle will
>> automatically give me degree 3 consistency.

I am also interested in automatically getting degree 3 consistency with Oracle V7. In DB2/6000 I can set the default degree of isolation on a database through the command kline processor or administrative API's. Does Oracle V7 have a similar facility?

Please post any replies to this on the net.

Regards,
Dex

---
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
Dexter P. Bradshaw                   \ Internet: dpbradsh_at_bluebox.uwaterloo.ca
Phone (Home): (519) 884-1855         \   Office: DC2306B, University of Waterloo
       (Off): (519) 885-4783 (x4783) \    Post: 200 University Av W.,
Fax         : (519) 885-1208         \          Waterloo, Ont N2L 3G1
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
------------------------------------------------------------------------------