Re: locking in Oracle

In a previous article, dean_at_cs.uq.oz.au (Dean Kuo) says:

>I want my transactions in Oracle to have repeatable reads...

If the first statement of a transaction is...

   SET TRANSACTION READ ONLY;    You will get a consitent (albeit read-only) snapshot of the entire database until the next ROLLBACK/COMMIT.

   If you want to play with consistency for the entire database, take a look at the following two init.ora parameters:

   serializable
   row_locking

   Note that setting these to their non-default values will cause a lot more lock waiting and increase the risk of deadlocks.

   Hope this helps,

• Doug Harris Database Administrator, System Development Division, Statistics Canada ## Standard Disclaimer Applies ## --