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.

Please send replies to: dean_at_cs.uq.oz.au

Thanks in advance
dean

-- 


____

Dean Kuo                             email: dean_at_cs.uq.oz.au
Department of Computer Science       phone: (work) +61-7-365-4193 
University of Queensland             fax: +61-7-365-1999
QLD, 4072, AUSTRALIA
--


____

Dean Kuo                             email: dean_at_cs.uq.oz.au
Department of Computer Science       phone: (work) +61-7-365-4193 
University of Queensland             fax: +61-7-365-1999